vb.org Archive - SQL errors from import.

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - SQL errors from import. (https://vborg.vbsupport.ru/showthread.php?t=219344)

James Birkett

07-24-2009 12:29 PM

SQL errors from import.

I exported my SQL a couple of days ago, and it's all been fixed today (imported etc).
However, Now I get errors such as these:

Quote:

Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Friday, July 24th 2009 @ 06:27:44 AM
Error Date : Friday, July 24th 2009 @ 06:27:44 AM
Script : http://{site}/forum/admincp/options.php?null=0
Referrer : http://{site}/forum/admincp/index.php?do=nav
IP Address : xx.xx.xxx.xx
Username : James
Classname : vB_Database
MySQL Version : 5.0.81-community

Have I done something wrong during the import? :confused:

Lynne

07-25-2009 03:20 AM

Error code 28: No space left on device -
One or more partitions on your server is out of space or doesn't have enough space to complete this operation. You need to shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.
http://www.mysql.com/news-and-events...000000249.html

James Birkett

07-25-2009 06:04 PM

Yeah, I researched this and found it.
Thanks Lynne :)

All times are GMT. The time now is 09:14 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01264 seconds Memory Usage 1,712KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: