I used the change file method to upgrade because I have so many hacks and I ran the altertable for 6.3 to 6.4. At this point my forums will not display, here is the error I get on the top of the main site: <br /> <br />

I would look in mysql error logs for a detail of the problem.<br /><br />I would think offhand from my experience that it is related to the user table and the addition of the birthday field. You need to use phpmyadmin and check out the table. You can open up the altertable file and may have to manually add the user table query <br /><br /> ALTER TABLE w3t_Users<br /> ADD U_Birthday VARCHAR(10) NOT NULL DEFAULT '0',<br /> ADD U_ShowBday INT(1) NOT NULL DEFAULT '0',<br /> ADD U_TimeFormat VARCHAR(6),<br /> ADD U_Ignored TEXT,<br /> ADD U_OC_Userid VARCHAR(64),<br /> ADD INDEX birthday_ndx (U_Birthday,U_ShowBday)<br /><br />Now if the above query does not run try running<br /><br /> ALTER TABLE w3t_Users<br /> ADD U_ShowBday INT(1) NOT NULL DEFAULT '0',<br /> ADD U_TimeFormat VARCHAR(6),<br /> ADD U_Ignored TEXT,<br /> ADD U_OC_Userid VARCHAR(64),<br /> ADD INDEX birthday_ndx (U_Birthday,U_ShowBday)<br /><br />At least thats what I remember when I upgraded a clean a few clean installs but all that had the birthday hack.

Neither of those worked. I suspected out of all the hacks I have installed that this wouldn't be a clean upgrade lol. Any other ideas?

update, even though I got errors with the command something took because the site is displaying properly now.

Glad it worked for you.

Omegatron, I am not sure if this is causing my issue or not but when birthday's are entered they are not kept (I am also having this issue with avars, it only seems to be on my site) you can enter it fine but then when you go back it's gone.

You would have to check your tables and check and see if they were formed.<br /><br />Josh posted a birthday script to modify and update peoples birthdays to the new 6.4 on here

Yes, if you were running the birthday mod - then the altertable will fail until you run my conversion script - because the U_Birthday field already exists.

Not sure which script that is, is it the bday cron script? http://www.ubbdev.com/forum/showflat...prev=#Post86334

No - did you run the Birthday mod before?<br /><br />If so you need this:<br />http://www.ubbdev.com/forum/showflat...art/3#Post96491

Okay I ran this, also keep in mind that I did what Omegatron explained above. Nothing is working now, I can't explain all of it just jump in over there and try to look at posts or profiles. If need be I will shut down and pull out a backup, please let me know.

Here is what the error log reports. I went ahead and closed the boards until it's worked out. <br /> <br />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,t2.U_Visible FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_Main = 16373 AND t1.B_PosterId = t2.U_Number AND B_Approved = 'yes' ORDER BY B_Number LIMIT 20 - Unknown column 't2.U_Birthday' in 'field list' <br /> <br />(sorry about the scroll)

I am going to pull out a backup. This disclaimer in your post Josh (Backup your database first! I developed this for my own needs so use at your own risk. ) is not kidding <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />

I found that his script added the birthday fields for the users but then made everything out of whack as it renames U_Birthday to U_BirthdayOLD and never made a NEW U_Birthday

It has this in it, doesn't this add it?<br />

Yeah well when I ran mine it said database only available to admins LOL I was logged in as admin

It should add it. <br /><br />Were there any errors that it couldn't be run.<br /><br />The problem is that we had a U_BirthDay field from the old mod - the the 6.4 altertable fails on the whole query when it tries to add a bunch of new stuff.<br /><br />I can help you get it fixed - but right now I get "forbidden" errors.<br /><br />If you've got PhpMyAdmin - PM me with access and I should be able to get you all fixed up.<br /><br />I think that some fields didn't get properly added when you did the 6.4 upgrade. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

Well just as an FYI Josh when I ran it on my test forum it converted the users and changed the field name to old but never created a new one.

I wonder if the initial 6.4 altertable query did not fail for you - then mine just redoes that query - but some of the fields already existed, so the query failed.<br /><br />In other words - it puzzled me that the altertable failed, although it doesn't on all servers. My Field was U_BirthDay - the new field is U_Birthday but on a Linux server, it says the field already exists. Not sure if different setups might not have had a problem with it.

Try this one - rename it .php and run it.<br /><br />I split the creation of the new fields into separate queries, so if one of the fields already exists, it won't blow the whole thing. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />