|
|
Joined: May 2003
Posts: 48
User
|
|
User
Joined: May 2003
Posts: 48 |
When searching for a user in teh admin page, it's returning:
SQL ERROR: Unable to do_query: SELECT U_Username,U_Number,U_Registered,U_Totalposts,U_Laston,U_Email,U_RegEmail,U_Status,U_Title,U_LoginName FROM w3t_Users WHERE U_Number <> 1 AND U_Number <> 2 AND U_Approved = 'yes' AND (U_Username LIKE '%l%' OR U_LoginName LIKE '%l%') ORDER BY U_Username
Got error 127 from table handler
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forums/mysql.inc.php on line 160
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forums/mysql.inc.php on line 133
at the top of the page. Any idea guys?
|
|
|
|
|
Joined: Aug 2000
Posts: 1,609
Addict
|
|
Addict
Joined: Aug 2000
Posts: 1,609 |
Try running this query...
REPAIR TABLE w3t_Users
|
|
|
|
|
Joined: May 2003
Posts: 48
User
|
|
User
Joined: May 2003
Posts: 48 |
Thanks for the that. Josh recently helped me with another problem and he said to use REPAIR TABLE w3t_Ratings and after looking at the code I can see where I could have just changed this. I'm not very tech minded so thought I'd better ask. Cheers mate.
|
|
|
|
|
Joined: Aug 2000
Posts: 1,609
Addict
|
|
Addict
Joined: Aug 2000
Posts: 1,609 |
I like to be helpful every now and then. 
|
|
|
|
|
Joined: Sep 2003
Posts: 803
Coder
|
|
Coder
Joined: Sep 2003
Posts: 803 |
Hey DLW, Can you get this one? When anyone goes into their "my home" to edit something they get this, SQL ERROR: Thu, May 20 2004 05:45:54 -0700 Unable to do_query: UPDATE w3t_Users SET <br />U_ProfileHash='161d1d6150b6108aaf17fbbaa94924ad' WHERE U_Number='5' <br />Unknown column 'U_ProfileHash' in 'field list'
|
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
U_ProfileHash was a new field added in 6.4.1 - did you run the 6.4-6.4.1 altertable script? Looks like you missed that step when upgrading, as that's where it was added. 
|
|
|
|
|
Joined: Sep 2003
Posts: 803
Coder
|
|
Coder
Joined: Sep 2003
Posts: 803 |
How did you get to be so smart. ;-\
|
|
|
|
|
Joined: Jun 2003
Posts: 1,025
Junior Member
|
|
Junior Member
Joined: Jun 2003
Posts: 1,025 |
He bought a gilded brain brain from a group of singing knomes...or was that me?
|
|
|
|
|
Joined: Aug 2000
Posts: 1,609
Addict
|
|
Addict
Joined: Aug 2000
Posts: 1,609 |
His secret is his Oreo intake. The creamy, white filling contains trace amounts of a chemical that the CIA developed in the 1950s to create a race of super spies.
|
|
|
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.
|
|
|
Posts: 808
Joined: July 2001
|
|
|
Forums63
Topics37,583
Posts293,955
Members13,826
| |
Most Online151,614
Nov 14th, 2025
|
|
Currently Online 3681
Topics Created 0
Posts Made 0
Users Online 0
Birthdays 13
|
|
|
|
