I'm currently using Threads under a windows environment and am in the process of converting my server over to Red Hat 9 (Shrike). I am able to successfully setup threads as a fresh installation under linux. However, whenever I import a threads database, things break all of a sudden. I always get a page full of these errors:
<br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/ubbthreads/mysql.inc.php on line 131<br />SQL ERROR: Database error only visible to forum administrators<br />
I'm not sure why this happens only on import. Is there something I have to do when converting from a windows based mysql to a linux based?
I'm using the following versions: mySQL : mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) PHP Version 4.2.2 Apache HTTP Server Version 2.0
After doing some more searching here on the forums, I found a tip from Navaho that shows more information about the error. The tip can be found at this link (Showing details when admin cant login)
Here is a more detailed error message:
<br />SQL ERROR: Unable to do_query: SELECT U_FrontPage, U_Groups, U_TimeOffset,U_Display,U_Favorites,U_WhichForums,U_Categories,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned FROM w3t_Users WHERE U_Number = '' <br />Table 'WWWThreads.w3t_Users' doesn't exist <br />
I doublechecked, and the table is there. I did notice one thing. In the code above, w3t_Users, the users is capitalized. When I view the database in MyPhpAdmin, it shows up in all lowercase, w3t_users.
Could this be the problem? And, if so, how do I change the database to match up? Thanks again