SiteWorksPro

Mitch -- I was restoring my MySQL 3.23 database from my local machine running W2K to my hosting company's MySQL 3.23 database running under FreeBSD and ran into a slight problem.

The dbsetup.php script worked fine initally and the site was accessing the database, etc. without errors.

However, after dropping all the tables and loading my backup database using phpAdmin, the website would not return any rows and gave errors on every mysql_num_rows function -- even though I had rows in the table.

After playing with it for about 30 minutes, I realized that the table names are case sensitive.

I'm not sure if its a phpAdmin thing or the W2K mysqldump, but I had to go through the backup script and change the first character in every word within a tablename to uppercase.

I also had to remove all the SQL comment lines (-- hypens) for it to run the SQL.

Everything is working fine now.

You may want to create a FAQ for this in case others run into the same problem.


The only other problem I've seen so far is the image uploads appear not to work. The images come up empty -- the upload appears to work without errors, however.

Oh well -- I left a message for tech support!

...david

Thanks, we will look into that.