Issue while moving servers
 

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.

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

Tried all that didn't work.

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

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?

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.