split from 'please help'

[Pete99]

Hmmm...I don't see how. Nonetheless I would download a new zip file and upload all the original vB files.

I just got the same error after update


Let me just add, I cannot access my admin now.

[Steve Machol]

Split from the original thread because we want to concentrate on each individual's problem.

Have you done what I suggested, i.e., download the latest zip file and reupload the original files? If you do this and you haven't added any code to your headinclude, header or phpinclude templates, then you shouldn't have this problem.

[Pete99]

Split from the original thread because we want to concentrate on each individual's problem.

Have you done what I suggested, i.e., download the latest zip file and reupload the original files? If you do this and you haven't added any code to your headinclude, header or phpinclude templates, then you shouldn't have this problem.

Actually facing a monster of a problem right now. I just removed the updated files.. and tried to restore a backup made last night.

Well.. it seems that my template table is not inserting without error into the database. Everything else went in fine.

I keep getting this error with just the Template table dump:
#1064 - 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 '' at line 2

[Steve Machol]

Simply uploading the updated files would not cause a db problem like this. And neither would restoring the files you were running before. Have you installed any hacks or modifications to the headinclude, header or phpinclude templates?

[Pete99]

Well.. I do have the v3arcade installed.. and a template (vbskinz). So my problem may lay in that arcade.

[Pete99]

Have any suggestions on how I can get my forum back online with a bad template table in the database?

Or just recover in general with posts/catagories/permissions/members intact?

[Pete99]

I have uploaded everything fresh.. I've got a blank page, but able to access the Admin now.

But the forum is blank. No templates in the database.. Help?

[Zachery]

Its almost impossible to have no templates in the database :/
Try importing the default style by uploading/downloading function in the style area.

[Pete99]

My template table is at 0. I tried to upload a style.. came back with an sql error.

I had to revert to a database backup.. everything was recovered from the sql backup except the Template table.

[Steve Machol]

I'm afraid to ask how you ended up with no template table. However in RC4, this is the query to create it (assuming you did not use a table prefix):

CREATE TABLE template (
templateid INT UNSIGNED NOT NULL AUTO_INCREMENT,
styleid SMALLINT NOT NULL DEFAULT '0',
title VARCHAR(100) NOT NULL DEFAULT '',
template MEDIUMTEXT NOT NULL,
template_un MEDIUMTEXT NOT NULL,
templatetype enum('template','stylevar','css','replacement') NOT NULL default 'template',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
username VARCHAR(50) NOT NULL DEFAULT '',
version VARCHAR(30) NOT NULL DEFAULT '',
PRIMARY KEY (templateid),
UNIQUE KEY title (title, styleid)
)
;

[Pete99]

I'm afraid to ask how you ended up with no template table. However in RC4, this is the query to create it (assuming you did not use a table prefix):

CREATE TABLE template (
templateid INT UNSIGNED NOT NULL AUTO_INCREMENT,
styleid SMALLINT NOT NULL DEFAULT '0',
title VARCHAR(100) NOT NULL DEFAULT '',
template MEDIUMTEXT NOT NULL,
template_un MEDIUMTEXT NOT NULL,
templatetype enum('template','stylevar','css','replacement') NOT NULL default 'template',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
username VARCHAR(50) NOT NULL DEFAULT '',
version VARCHAR(30) NOT NULL DEFAULT '',
PRIMARY KEY (templateid),
UNIQUE KEY title (title, styleid)
)
;

No dump required? I have that part of it.. I just can't successfully get the dump in there from the database backup.. keeps coming up with an error on that dump.

[Steve Machol]

Sorry I don't understand the part about the 'dump'. What are you doing exactly and what happens?