NOTES ON Geoclassifieds Lite installation for MySql. As portable as possible. Want avoid MySql-specific or PHP-specific. Going by installation.txt file. Do step 5 before step 4. Doing PHPMYADMIN option, which is really SQL file (a.o.t. PHP script). sql/initial.sql does not exist. So, executing sql/?.sql via SqlTool. PREP: They all have # coments, which is generally ok since SqlTool just passes these to the DB engine with the following SQL statement. Only problem is at end. Just add a ";" to end of each file to send the trailing comment to the DB engine. #6. Contrary to docs, it does croak because files that it's trying to create already exist. I guess this means that the database does not need to be updated??? I set "admin" password to "barf". 1st user account: morgan / m0rgan next: blaine / plainb Must CREATE and set perms on the image directory. It won't create the directory for you. site general management screen broken. Trying to insert a string into the non-null integer use_api field. Ditto for 2 other small_int fields. if ($configuration_info["use_api"] == '') $configuration_info["use_api"] = "0"; if ($configuration_info["use_ssl_in_sell_process"] == '') $configuration_info["use_ssl_in_sell_process"] = "0"; if ($configuration_info["admin_approves_all_ads"] == '') $configuration_info["admin_approves_all_ads"] = "0"; Ditto for classes/register_class.php newletter field. ~ line 2351. installation.txt misnames menu Ad Configuration / Images Configuration. "directory path to images directory:"? Absolute path to "url path to image directory..." above? Remove trailing line from classes/site_class.php to prohibit the included file from writing white space. (And thereby committing the HTTP response). admin/admin_site_configuration_class.php $fpby = (($configuration_info["footer_powered_by_link"] == '') ? "0" : $configuration_info["footer_powered_by_link"]); ... footer_powered_by_link = \"".$fpby."\", ##################################################### IE BUGs: Active Ads page bounces to home page. (17:51:20) Deb: Fatal error: Uncaught exception 'javaexception' with message 'com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'business_type' at row 2' in /srv/www/tomcat5/beyla/webapps/geoclassifieds/classes/adodb-jdbc223.php:104 Stack trace: #0 /srv/www/tomcat5/beyla/webapps/geoclassifieds/classes/register_class.php(324): JDBCConnection->Execute('update geodesic...') #1 /srv/www/tomcat5/beyla/webapps/geoclassifieds/classes/register_class.php(348): Register->save_form_variables('update geodesic...') #2 /geoclassifieds/register.php(532): Register->check_info(Object(JDBCConnection)) #3 {main} thrown in /srv/www/tomcat5/beyla/webapps/geoclassifieds/classes/adodb-jdbc223.php on line 104 2006-02-13 17:58:00,519 ERROR adodb-jdbc223.php com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'business_type' at row 10 From SQL: update geodesic_classifieds_registration_session set email = "morgan@admc.com", email_verifier = "morgan@admc.com", username = "Morgan", password = "morgan598", company_name = "", firstname = "Morgan", lastname = "Simpson", address = "2171+Leetown+Road", address_2 = "", city = "Summit+Point", state = "WV", country = "United States", zip = "", phone = "3047286872", phone_2 = "", fax = "", business_type = "", agreement = "1", url = "" where session = "724ef468f9ceb90742010f533cefeb85" ##################################################### Following table should permit nulls: alter table GEODESIC_CLASSIFIEDS_REGISTRATION_SESSION alter column email set null; alter table GEODESIC_CLASSIFIEDS_REGISTRATION_SESSION alter column email_verifier set null; alter table GEODESIC_CLASSIFIEDS_REGISTRATION_SESSION alter column USERNAME set null; alter table GEODESIC_CLASSIFIEDS_REGISTRATION_SESSION alter column PASSWORD set null; alter table GEODESIC_CLASSIFIEDS_REGISTRATION_SESSION alter column PASSWORD_VERIFIER set null; alter table GEODESIC_CLASSIFIEDS_REGISTRATION_SESSION alter column COMPANY_NAME set null; ****************************************88 CLONING Enterprise version PPT database. Used phpmysqladmin to make an SQL dump. Did not back-tick object names. Had to apply back-ticks to the two object names that contain hyphens. Adding the chdir command to top-level php files. I see that absolute filepaths are used everywhere. Therefore, I just used perl to switch my doc root for /home/performa/public_html in all occurrences. Seems that preset var $_SERVER["SERVER_NAME"] is set (and probably more reliable than) $_SERVER["HTTP_HOST"]. ##### CONFIGURING Enterprise ### Apache->JSR changes See php.ini file. For inclusion, set the doc root as the include_path, then change all includes and requires in other directories. vim +/require_once admin/admin_universal_management_class.php admin/admin_universal_management_class.php classes/site_class.php classes/classified_sell_class2.php classes/backup/classified_sell_class.php classes/classified_sell_class.php email/htmlMimeMail.php email/htmlMimeMail.php Includes/requires can't begin with "." or they only work with $PWD (which JSR doesn't maintain). Change is_file() and file_exists to use WEBPATH + /. Ditto for function getfile() in xtpl.php files. look for fread(), fwrite(, file(, readfile(. admin/admin_registration_configuration_class.php shows my mods to make integer nullable column updates entirely optinal; and non-nullable integer columns to write ((int) x)'s, without double-quotes. When export Geo data, wipe out the two non-standardly-named tables ads-backup and classifieds_bak_7-5-2005. register_globals has caused a variable collission with $show, which is used as a return variable for queries, and for the HTTP param for user selection of answers-per-page. BUG ON ALL SITES: If try to continue after add category but no sub-category, the steps get stuck.