upgrade problem for 3.5.5 to 3.6.1

[dimeola]

Can you help me? Why i take this message, when i try to upgrade my vbullet?

Step 7) Signature Permissions

Creating sigpic table
Altering usergroup Table (1 of 9)
Altering usergroup Table (2 of 9)
Altering usergroup Table (3 of 9)
Altering usergroup Table (4 of 9)
Altering usergroup Table (5 of 9)
Altering usergroup Table (6 of 9)
Altering usergroup Table (7 of 9)
Altering usergroup Table (8 of 9)
Altering usergroup Table (9 of 9)
Altering user Table (1 of 1)
Creating sigparsed table
Altering setting Table (1 of 1)
Renaming post_parsed table to postparsed
Updating Thread Redirects
Altering forum Table (1 of 3)
Altering forum Table (2 of 3)
There seems to have been a problem with the Avareyiz Forumu database.

Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.




Database error in vBulletin 3.5.5:

Invalid SQL:

;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'lastpost' at line 2

Error Number : -1

Date : Tuesday, September 19th 2006 @ 12:31:16 AM

Script : http://www.***.com/Forum/install/upgrade_360b1.php?step=7

Referrer : http://www.***.com/Forum/install/upgrade_360b1.php?step=6

IP Address : 85.100.234.182

Username :

Classname : vb_database

[Marco van Herwaarden]

Is that the full SQL-error?

Try refreshing the page (or run upgrade.php again) and see if that fix your problem.

How many post do you have on your board?

[dimeola]

Is that the full SQL-error?

Try refreshing the page (or run upgrade.php again) and see if that fix your problem.

How many post do you have on your board?

i refreshed many times. we have over 80000 posts in our board.

[dimeola]

one of the mail like this

Database error in vBulletin 3.5.5:

Invalid SQL:
;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'lastpost' at line 2
Error Number : -1
Date : Tuesday, September 19th 2006 @ 12:31:16 AM
Script : http://www.***.com/Forum/install/upgrade_360b1.php?step=7 (http://www.***.com/Forum/install/upgrade_360b1.php?step=7)
Referrer : http://www.***.com/Forum/install/upgrade_360b1.php?step=6 (http://www.***.com/Forum/install/upgrade_360b1.php?step=6)
IP Address : 85.100.234.182
Username :
Classname : vb_database


another mail like this
Database error in vBulletin 3.5.5:

Invalid SQL:

SELECT announcementid, announcementid AS postid, startdate, enddate, announcement.title, pagetext, allowhtml, allowbbcode, allowsmilies, views,
user.*, userfield.*, usertextfield.*,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight

FROM announcement AS announcement
LEFT JOIN user AS user ON(user.userid=announcement.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid=announcement.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid=user.avatarid)
LEFT JOIN customavatar AS customavatar ON(customavatar.userid=announcement.userid)


WHERE startdate <= 1158688239
AND enddate >= 1158688239
AND announcement.forumid IN (43,41,-1)
ORDER BY startdate DESC;

MySQL Error : Unknown column 'allowhtml' in 'field list'
Error Number : 1054
Date : Tuesday, September 19th 2006 @ 12:50:40 AM
Script : http://www.***.com/announcement.php?f=43 (http://www.***.com/announcement.php?f=43)
Referrer :
IP Address : 66.249.65.46
Username : Unregistered
Classname : vb_database

[Marco van Herwaarden]

The second error is because you are trying to use 3.6 software with a database that is not fully upgraded yet. For now you should ignore that error.

I suggest you start by reuploading all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Now run the upgrade again. Do you still get this error?

[dimeola]

thank you very muchhhhh :) but we have a small problem. we can`t go to last post of thread. when we click "go to lastpost" button, we see the error which you see below.

No Thread specified. If you followed a valid link, please notify the administrator


we see the link like this


www.***.com/showtread.php?p=0#post0 (http://www.***.com/showtread.php?p=0#post0)

[Marco van Herwaarden]

To troubleshoot this, please create a new Style with no Parent set. Now browse the forum using this new style, do you still have the same problems?

[dimeola]

we create new style and made it default, but that did not solve our problem :(

[Marco van Herwaarden]

Please open a support ticket with a description of the problem, and access details for AdminCP, FTP/SSH and phpMyAdmin.

[dimeola]

hi,

our issueid is 489073.

thank you very much for your help :D

[dimeola]

thank you very very much. we love vbulletin team :))))))))))))