HaMi Posted June 14, 2010 Share Posted June 14, 2010 Hi Guys, i am new to this site, if i made a mistake then i am sorry for this. i am having this issue on my database i run a vbulletin forum with 30 000+ registered members one admin moved all threads to one section and i wanted to implement the backup i took on 12.06.2010 via Vbulletin AdminCP now the issue i am having is normaly vbulletin have 177+ tables. when i tried to implent this via "Bigdump" it implemented only 87 tables. i tried the same with SSH it went to 110 tables but it ended aswell with this error: ERROR 1064 (42000) at line 287379: 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 '<br /> <b>Fatal error</b>: Maximum execution time of 30 seconds exceeded in <b>' at line 1 can someone help me on this? i will be really thankful Regards, HaMi Quote Link to comment https://forums.phpfreaks.com/topic/204770-error-1064-42000-at-line-287379-you-have-an-error-in-your-sql-syntax/ Share on other sites More sharing options...
HaMi Posted June 14, 2010 Author Share Posted June 14, 2010 now i tried even dumping it via MySql Dumper it gave this error: Array ( [max_zeit] => 22 [startzeit] => 1276515827 [xtime] => 1276515461 [fileEOF] => [actual_table] => post [offset] => 170383526 [aufruf] => 114 [table_ready] => 87 [part] => 0 [do_it] => [errors] => 0 [notices] => 0 [anzahl_eintraege] => -1 [anzahl_tabellen] => -1 [filename] => vbulletin.sql [actual_fieldcount] => 0 [eintraege_ready] => 264349 [anzahl_zeilen] => 17277 [summe_eintraege] => 259003 [erweiterte_inserts] => 0 [flag] => -1 [EOB] => [dump_encoding] => utf8 [compressed] => 0 [tables_to_restore] => [filehandle] => Resource id #13 [tablelock] => 0 [insert_syntax] => INSERT INTO post ) Sql: <br /> Erweiterte Inserts: 0 unknown SQL-Command: Fatal error: Maximum execution time of 60 seconds exceeded in /home/mm/www/forums/includes/adminfunctions_backup.php on line 63 Quote Link to comment https://forums.phpfreaks.com/topic/204770-error-1064-42000-at-line-287379-you-have-an-error-in-your-sql-syntax/#findComment-1072080 Share on other sites More sharing options...
fenway Posted June 15, 2010 Share Posted June 15, 2010 That's in your php config -- override it for admin functions. Quote Link to comment https://forums.phpfreaks.com/topic/204770-error-1064-42000-at-line-287379-you-have-an-error-in-your-sql-syntax/#findComment-1072368 Share on other sites More sharing options...
HaMi Posted June 15, 2010 Author Share Posted June 15, 2010 but i tried this with different database backups which i took from january till now.. all have this error on different lines.. Quote Link to comment https://forums.phpfreaks.com/topic/204770-error-1064-42000-at-line-287379-you-have-an-error-in-your-sql-syntax/#findComment-1072382 Share on other sites More sharing options...
fenway Posted June 16, 2010 Share Posted June 16, 2010 but i tried this with different database backups which i took from january till now.. all have this error on different lines.. I don't understand what that means. Quote Link to comment https://forums.phpfreaks.com/topic/204770-error-1064-42000-at-line-287379-you-have-an-error-in-your-sql-syntax/#findComment-1072954 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.