UBB.Developers Forums UBB.threads 7 Development How Do I? Upgrade error SQL ERROR: Unable to do_query: REPLACE INTO w3t_Online

Uh oh...what'd I do...got this by running altertable-6.4-6.4.1php.

SQL ERROR: Wed, Feb 11 2004 21:47:29 -0500 Unable to do_query: REPLACE INTO w3t_Online (O_Username,O_Uid,O_Last,O_What,O_Board,O_Extra,O_Read,O_Type) VALUES ('Administrator','2','1076554049','all_admin','','','','r')
Unknown column 'O_Board' in 'field list'

And these in the error log (snip):
Unable to do_query: SELECT t1.B_Number,t2.U_Username,t1.B_Posted,t1.B_IP,t1.B_Subject,t1.B_Body,t1.B_File,t1.B_Status,t1.B_Approved,t2.U_Picture,t1.B_Reged,t2.U_Title,t2.U_Color,t1.B_Icon,t1.B_Poll,t1.B_Parent,t2.U_Status,t2.U_Signature,t1.B_LastEdit,t1.B_LastEditBy,t2.U_Location,t2.U_TotalPosts,t2.U_Registered,t2.U_Rating,t2.U_Rates,t2.U_RealRating,t2.U_PicWidth,t2.U_PicHeight,t2.U_Number,t1.B_FileCounter,t1.B_AnonName,t1.B_ParentUser,t2.U_Birthday,t2.U_ShowBday,t1.B_AddSig FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_Main = 7725 AND t1.B_PosterId = t2.U_Number AND B_Approved = 'yes' ORDER BY B_Number LIMIT 10 - Unknown column 't2.U_Birthday' in 'field list'

Wed, Feb 11 2004 21:52:52 -0500 /2pop/ubbthreads/togglesub.php 65.54.188.42
Unable to do_query: REPLACE INTO w3t_Online (O_Username,O_Last,O_What,O_Board,O_Read,O_Type,O_Extra) VALUES ('-ANON-65.54.188.42','1076554372','togglesub','jobs','','a','') - Unknown column 'O_Board' in 'field list'

Wed, Feb 11 2004 21:52:53 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: SELECT U_PictureView,U_Number,U_TimeOffset,U_TimeFormat,U_Ignored,U_OC_Userid,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned FROM w3t_Users WHERE U_Number = '' - Unknown column 'U_TimeFormat' in 'field list'

Wed, Feb 11 2004 21:52:53 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: SELECT U_Username,U_Fakeemail,U_Name,U_Totalposts,U_Homepage,U_Occupation,U_Hobbies,U_Location,U_Bio,U_Extra1,U_Extra2,U_Extra3,U_Extra4,U_Extra5,U_Registered,U_Picture,U_Title,U_Status,U_Number,U_Rating,U_Rates,U_Picwidth,U_Picheight,U_Birthday,U_ShowBday,U_CoppaUser,U_OC_Userid FROM w3t_Users WHERE U_Number = '893' - Unknown column 'U_Birthday' in 'field list'

Wed, Feb 11 2004 21:52:53 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: REPLACE INTO w3t_Online (O_Username,O_Last,O_What,O_Board,O_Read,O_Type,O_Extra) VALUES ('-ANON-65.54.188.42','1076554373','showprofile','PanasonicAGDVX100Camera','','a','') - Unknown column 'O_Board' in 'field list'

Wed, Feb 11 2004 21:52:57 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: SELECT U_PictureView,U_Number,U_TimeOffset,U_TimeFormat,U_Ignored,U_OC_Userid,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned FROM w3t_Users WHERE U_Number = '' - Unknown column 'U_TimeFormat' in 'field list'

Wed, Feb 11 2004 21:52:57 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: SELECT U_Username,U_Fakeemail,U_Name,U_Totalposts,U_Homepage,U_Occupation,U_Hobbies,U_Location,U_Bio,U_Extra1,U_Extra2,U_Extra3,U_Extra4,U_Extra5,U_Registered,U_Picture,U_Title,U_Status,U_Number,U_Rating,U_Rates,U_Picwidth,U_Picheight,U_Birthday,U_ShowBday,U_CoppaUser,U_OC_Userid FROM w3t_Users WHERE U_Number = '602' - Unknown column 'U_Birthday' in 'field list'

Wed, Feb 11 2004 21:52:57 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: REPLACE INTO w3t_Online (O_Username,O_Last,O_What,O_Board,O_Read,O_Type,O_Extra) VALUES ('-ANON-65.54.188.42','1076554377','showprofile','PanasonicAGDVX100Camera','','a','') - Unknown column 'O_Board' in 'field list'

Wed, Feb 11 2004 21:52:58 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: SELECT U_PictureView,U_Number,U_TimeOffset,U_TimeFormat,U_Ignored,U_OC_Userid,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned FROM w3t_Users WHERE U_Number = '' - Unknown column 'U_TimeFormat' in 'field list'

Wed, Feb 11 2004 21:52:58 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: SELECT U_Username,U_Fakeemail,U_Name,U_Totalposts,U_Homepage,U_Occupation,U_Hobbies,U_Location,U_Bio,U_Extra1,U_Extra2,U_Extra3,U_Extra4,U_Extra5,U_Registered,U_Picture,U_Title,U_Status,U_Number,U_Rating,U_Rates,U_Picwidth,U_Picheight,U_Birthday,U_ShowBday,U_CoppaUser,U_OC_Userid FROM w3t_Users WHERE U_Number = '2239' - Unknown column 'U_Birthday' in 'field list'

Wed, Feb 11 2004 21:52:58 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: REPLACE INTO w3t_Online (O_Username,O_Last,O_What,O_Board,O_Read,O_Type,O_Extra) VALUES ('-ANON-65.54.188.42','1076554378','showprofile','PanasonicAJSDX900Camera','','a','') - Unknown column 'O_Board' in 'field list'

Wed, Feb 11 2004 21:53:00 -0500 /2pop/ubbthreads/ubbthreads.php 67.163.10.215
Unable to do_query: SELECT U_FrontPage, U_Groups, U_TimeOffset,U_Display,U_Favorites,U_WhichForums,U_Categories,U_TimeFormat,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned FROM w3t_Users WHERE U_Number = '' - Unknown column 'U_TimeFormat' in 'field list'

Wed, Feb 11 2004 21:53:00 -0500 /2pop/ubbthreads/ubbthreads.php 67.163.10.215
Unable to do_query: REPLACE INTO w3t_Online (O_Username,O_Last,O_What,O_Board,O_Read,O_Type,O_Extra) VALUES ('-ANON-67.163.10.215','1076554380','ubbthreads','','','a','') - Unknown column 'O_Board' in 'field list'

Wed, Feb 11 2004 21:53:04 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: SELECT U_PictureView,U_Number,U_TimeOffset,U_TimeFormat,U_Ignored,U_OC_Userid,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned FROM w3t_Users WHERE U_Number = '' - Unknown column 'U_TimeFormat' in 'field list'

Wed, Feb 11 2004 21:53:04 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: SELECT U_Username,U_Fakeemail,U_Name,U_Totalposts,U_Homepage,U_Occupation,U_Hobbies,U_Location,U_Bio,U_Extra1,U_Extra2,U_Extra3,U_Extra4,U_Extra5,U_Registered,U_Picture,U_Title,U_Status,U_Number,U_Rating,U_Rates,U_Picwidth,U_Picheight,U_Birthday,U_ShowBday,U_CoppaUser,U_OC_Userid FROM w3t_Users WHERE U_Number = '8' - Unknown column 'U_Birthday' in 'field list'

Wed, Feb 11 2004 21:53:04 -0500 /2pop/ubbthreads/showprofile.php 65.54.188.42
Unable to do_query: REPLACE INTO w3t_Online (O_Username,O_Last,O_What,O_Board,O_Read,O_Type,O_Extra) VALUES ('-ANON-65.54.188.42','1076554384','showprofile','PanasonicAJSDX900Camera','','a','') - Unknown column 'O_Board' in 'field list'

Wed, Feb 11 2004 21:53:09 -0500 /2pop/ubbthreads/printthread.php 65.54.188.42
Unable to do_query: SELECT U_Display,U_Groups,U_PostsPer,U_PicturePosts,U_FlatPosts,U_TempRead,U_TimeOffset,U_TimeFormat,U_Username,U_Password,U_SessionId, U_StyleSheet, U_Status, U_Privates, U_FrontPage, U_Number, U_Banned FROM w3t_Users WHERE U_Number = '' - Unknown column 'U_TimeFormat' in 'field list'

What were you upgrading from?

You're missing some fields in your database.

O_Board and U_TimeFormat in the w3t_Online table.

from 6.3.2 then to 6.4 then to 6.4.1 but I believe I forgot to run the update on the config file in the Admin area. I take it that's a required intermediary step, i.e., you can't just run the altertable scripts back to back? At the moment it's looking OK....

Did you run 2 altertables?

altertable-6.3-6.4.php
and
altertable-6.4-6.4.1.php

You must run each altertable, IN ORDER from your current version to the latest version.

I'd go back to your 6.3 database backup and run the 6.3-6.4 altertable first. My guess is that you missed that.

Yes that's exactly what I did...I just didn't update the config in the admin area after doing the 1st 1. So far so good--the errors have gone away...nothing in the SQL logs either since the problem went away. Sorry for the cross post...I just freaked out...

My forum (6.4) was just moved to a new server (no upgrade) and I get the following error:

SQL ERROR: Unable to do_query: SELECT t1.Mod_Board,t1.Mod_Uid,t2.U_Username FROM w3t_Moderators AS t1, w3t_Users AS t2 WHERE t1.Mod_Uid = t2.U_Number
Can't find file: './magle/w3t_moderators.frm' (errno: 13)
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /Library/Tenon/WebServer/WebSites/www.magle.dk/ubbthreads/mysql.inc.php on line 133
SQL ERROR: Unable to do_query: SELECT C_Users,C_NewUsername,C_NewUid,C_Users_timestamp,C_Birthdays,C_Birthdays_timestamp,C_MaxOnline,C_MaxOnline_timestamp FROM w3t_Cache
Can't find file: './magle/w3t_cache.frm' (errno: 13)
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /Library/Tenon/WebServer/WebSites/www.magle.dk/ubbthreads/mysql.inc.php on line 133
SQL ERROR: Unable to do_query: SELECT DISTINCT Cat_Title,Cat_Number,Cat_Description FROM w3t_Category WHERE Cat_Type = 'forum' ORDER BY Cat_Number
Can't find file: './magle/w3t_category.frm' (errno: 13)
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /Library/Tenon/WebServer/WebSites/www.magle.dk/ubbthreads/mysql.inc.php on line 133
SQL ERROR: Unable to do_query: UPDATE w3t_Cache SET C_Users = '46', C_NewUsername = 'Al@sdair', C_NewUid = '51', C_Users_timestamp = '1076680849', C_Birthdays = '', C_Birthdays_timestamp = '1076680849', C_MaxOnline = '6', C_MaxOnline_timestamp = '1076680849'
Can't find file: './magle/w3t_cache.frm' (errno: 13)

What can I do, running altertables won't help!

Hmm.... I'm not sure exactly what the error 13 is, but "can't find file" indicates that something may be missing vs. corruption which sometimes occurs. I'd contact your host.

Thanks

That's exactly what was wrong. None of the "w3t_" files could be accessed. Turns out my host had made an error when moving the SQL database. Luckily they was able to fix it and eveything is running like it should now.