View Single Post
Old April 13th, 2008, 05:55 PM   #1 (permalink)
fdwilk1
Member
Verified Customer
 
Join Date: May 2006
Posts: 33
Classifieds 3.01 Installation Problems

I am attempting to install a second copy of the PhotoPost Classifieds 3.01. I own two licenses. The second copy has its own MySQL database.

After my initial attempt of this second installation, I received a large number of the 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' error messages, the same as when I was upgrading my existing 2.61 installation two days ago. At you suggestion then, I removed all of the instances of the troublesome command. I did the same with install.php for a second attempt of the new installation.

After running install.php and getting the "installation is complete" screen, I get the following error messages:

Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 17
Error: Table 'ppclassifieds.cp_usergroups' doesn't exist
Error: Table 'ppclassifieds.cp_usergroups' doesn't exist
Error: Table 'ppclassifieds.cp_usergroups' doesn't exist
Error: Table 'ppclassifieds.cp_usergroups' doesn't exist
Error: Table 'ppclassifieds.cp_usergroups' doesn't exist

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/fdwilk4/remarkablecars.com/for-sale/forums/sellerspost.php:309) in /usr/home/fdwilk4/remarkablecars.com/for-sale/install.php on line 1346

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/fdwilk4/remarkablecars.com/for-sale/forums/sellerspost.php:309) in /usr/home/fdwilk4/remarkablecars.com/for-sale/install.php on line 1347

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/fdwilk4/remarkablecars.com/for-sale/forums/sellerspost.php:309) in /usr/home/fdwilk4/remarkablecars.com/for-sale/install.php on line 1365

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/fdwilk4/remarkablecars.com/for-sale/forums/sellerspost.php:309) in /usr/home/fdwilk4/remarkablecars.com/for-sale/install.php on line 1366


I have checked all of the PhotoPost files and can find no mention of the "usergroups" create table command. I also can find no remaining "utf8" commands.

Also, cp_ is not the correct prefix, which should be fs_.


At the "installation complete" screen, if I select the option to execute adm-index.php, I get the follwing error message at the top of the screen:


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/home/fdwilk4/remarkablecars.com/for-sale/pp-inc.php on line 3457


Please advise.

Thanks,

Doug Wilkinson
fdwilk1 is offline   Reply With Quote