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 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 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. 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.. 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. 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
Archived
This topic is now archived and is closed to further replies.