james86 Posted June 20, 2012 Share Posted June 20, 2012 ok never had this happen to me every time i go to install whmcs i get Internal Server Error when i install sql that come up 1st i get Internal Server Error some times i cant to the admin info fill it in hit button start to go then boom Internal Server Error i have got it to install 1 time out of like 45 trys but when you get the Internal Server Error i go back to the install it say upgrade from 3.0.2 or what ever i try upgrade over and over then i get We receiving the following error: Errors Occured Please open a ticket with the debug information below for support File: upgrade451.sql Line 1 - 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 '\'4.5.1\' WHERE setting=\'Version\'' at line 1 Errors Occured Please open a ticket with the debug information below for support File: upgrade452.sql Line 1 - 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 '\'4.5.2\' WHERE setting=\'Version\'' at line 1 Errors Occured Please open a ticket with the debug information below for support File: upgrade500.sql Line 1 - Duplicate column name 'homewidgets' Line 2 - Duplicate column name 'widgets' Line 3 - 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 '\'activity_log,getting_started,income_forecast,in come_overview,my_notes,network_' at line 1 Line 4 - 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 '\'activity_log,getting_started,income_forecast,in come_overview,my_notes,network_' at line 1 Line 5 - 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 '\'activity_log,getting_started,my_notes,todo_list ,whmcs_news\' WHERE `id`=3' at line 1 Line 6 - 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 '\'admin\', \'Support Ticket Department Reassigned\', \'[Ticket ID: {$ticket_tid}' at line 1 Line 7 - 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 '\'AttachmentThumbnails\',\'on\' )' at line 1 Line 8 - Duplicate column name 'onetime' Line 9 - Duplicate column name 'description' Line 10 - Duplicate column name 'recurringcycles' Line 11 - Duplicate column name 'allowqty' Line 12 - 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 '\'invoice\', \'Invoice Refund Confirmation\', \'Invoice Refund Confirmation\', \' at line 1 Line 13 - Duplicate column name 'nameserver5' Line 14 - Table 'tblemailmarketer' already exists Line 15 - Duplicate column name 'order' Line 16 - Table 'tblbundles' already exists Line 17 - Table 'tblmodulelog' already exists Line 18 - 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 '\'1\', \'101\'), (\'2\', \'101\'), (\'1\', \'102\'), (\'1\', \'103\')' at line 1 Line 19 - 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 '\'5.0.0\' WHERE setting=\'Version\'' at line 1 Errors Occured Please open a ticket with the debug information below for support File: upgrade501.sql Line 1 - Duplicate column name 'defaultgateway' Line 2 - Duplicate column name 'contactid' Line 3 - Duplicate column name 'contactid' Line 4 - Duplicate column name 'hidden' Line 5 - Duplicate column name 'orderdata' Line 6 - 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 '\'2\', \'71\'), (\'2\', \'73\'), (\'1\', \'104\'), (\'2\', \'104\'), (\'1\', \'1' at line 1 Line 7 - 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 '\'5.0.1\' WHERE setting=\'Version\'' at line 1 Errors Occured Please open a ticket with the debug information below for support File: upgrade502.sql Line 1 - Duplicate column name 'showgroup' Line 2 - 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 '\'5.0.2\' WHERE setting=\'Version\'' at line 1 Errors Occured Please open a ticket with the debug information below for support File: upgrade503.sql Line 1 - 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 '\'5.0.3\' WHERE setting=\'Version\'' at line 1 0 Quote Link to comment Share on other sites More sharing options...
james86 Posted June 21, 2012 Author Share Posted June 21, 2012 ok i can inport backup DB and it works but i cannt install a clean copy of whmcs 0 Quote Link to comment Share on other sites More sharing options...
laszlof Posted June 21, 2012 Share Posted June 21, 2012 Did you wipe the database prior to installing a fresh copy? It looks like you're trying to install into a database that already exists. 0 Quote Link to comment Share on other sites More sharing options...
james86 Posted June 21, 2012 Author Share Posted June 21, 2012 yes fresh copy db was clean every time or remade every time i install it clean i get Internal Server Error some point in the install so that stoping the install and sql not install full so its a older whmcs so i go back to the install link it ask me to upgrade 0 Quote Link to comment Share on other sites More sharing options...
james86 Posted June 21, 2012 Author Share Posted June 21, 2012 1// i think it some thing to do with the web server 2// i own a copy of whmcs and i havent paid the 44.95 for update but 5.0.3 come out after i got the owner licenses but i dont think whmcs stop you for not paying 0 Quote Link to comment Share on other sites More sharing options...
Administrators WHMCS John Posted June 22, 2012 Administrators Share Posted June 22, 2012 Hi, Unfortunately a 500 Internal Server Error is just a generic error message from your server, you'll need to check your server error logs for the actual cause of the error. With that information we can then assist in identifying the cause of the problem. 0 Quote Link to comment 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.