Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Jan 2001
Posts: 69
Power User
Power User
Joined: Jan 2001
Posts: 69
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:

Code
<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

Thanks

Sponsored Links
Joined: Feb 2002
Posts: 1,759
Addict
Addict
Offline
Joined: Feb 2002
Posts: 1,759
how are you trying to import it? Via command line, or phpMyAdmin?

Joined: Jan 2001
Posts: 69
Power User
Power User
Joined: Jan 2001
Posts: 69
I'm doing it by command line. First I drop the database that was created from the "fresh install". The steps are approximately:

mysqladmin drop WWWThreads
mysqladmin create WWWThreads
mysql WWWThreads < WWWThreads.dump

I can access the imported threads with phpMyAdmin, and the config scripts are staying the same as far as the user/pass that has access to the database.

Joined: Jan 2001
Posts: 69
Power User
Power User
Joined: Jan 2001
Posts: 69
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:
Code
 <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

Last edited by hatter; 07/08/2003 9:49 PM.
Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Something to check is if the fields are properly labled as far as case goes. On windows it doesn't matter becuase w3t_AddressBook = w3t_addressbook but on Linux it does not.

Here's a related link:

https://ubbdev.com/forum/showfl...collapsed&sb=5&o=186&fpart=1

Hope that helps.



Sponsored Links
Joined: Jan 2001
Posts: 69
Power User
Power User
Joined: Jan 2001
Posts: 69
Thanks! I'm sure now that this is the problem!!!

Joined: Jun 2001
Posts: 3,273
That 70's Guy
That 70's Guy
Offline
Joined: Jun 2001
Posts: 3,273
Your welcome. Thanks to Omegatron too. I was aware of this solution just never got around to posting it... lol

Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
Oh God this issue again. Yeah that one really got me a while back. Glad to see the SQL LIST will do some good.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Yeah, this has bit me before.

Joined: Jan 2001
Posts: 69
Power User
Power User
Joined: Jan 2001
Posts: 69
Thanks Omegatron, I was really pulling my hair out over that!

Sponsored Links
Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
If I had hair to pull out I would have been doing the same when I went through that issue.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Ruben Rocha
Ruben Rocha
Lutz,FL,USA
Posts: 253
Joined: January 2000
Forum Statistics
Forums63
Topics37,570
Posts293,915
Members13,848
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,829
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 81
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2022 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221129)