Issue while moving servers

[Loget]

I recently moved servers and I did everything ect but when I go to my site its just a blank page, I can access admincp fine but the homepage is just blank. Register globals is turned off by the way.

[snakes1100]

1. disable plugins
2. check and make sure url path is correct in admincp vbulletin options
3. try adding this ini_set('display_errors', TRUE); to the second line of config.php

[Loget]

Tried all that didn't work.

[snakes1100]

<a href="http://www.vbulletin.com/docs/html/blank_pages" target="_blank">http://www.vbulletin.com/docs/html/blank_pages</a>

[Loget]

Invalid SQL:

SELECT title, template, templatetype
FROM template
WHERE templateid IN ()
AND (templatetype <> 'template' OR title IN('editor_jsoptions_font', 'editor_jsoptions_size', 'editor_styles_button_normal', 'editor_styles_button_hover', 'editor_styles_button_down', 'editor_styles_button_selected', 'editor_styles_menu_normal', 'editor_styles_menu_hover', 'editor_styles_menu_down', 'editor_styles_popup_down'));

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 ')
AND (templatetype <> 'template' OR title IN('editor_jsoptions_font',


Looks like its a template error, I dont have a clue how to fix it.

--------------- Added [DATE]1236596709[/DATE] at [TIME]1236596709[/TIME] ---------------

Ive deleted the "template" table, I want to recreate it (making sure the syntax is correct) can somebody give me the code to create the template table again?

[snakes1100]

You shouldn't of dropped the table to fix a template issue, next time simply revert any modified template via the style manager in the admincp.

You can get the code you need, check the mysql-schema.php file in the do_not_upload folder.