ارور هنگام آپگرید - whmcs بازان بیان تو

من میخوام whmcs رو آپدیت کنم به 5.0.3 الان مال من 4.2.2 است اما هنگام آپگرید این رو دریافت میکنم:

کد:

Upgrade Complete Errors Occured Please open a ticket with the debug information below for support File: upgrade450.sql Line 1 - Duplicate column name 'startdate' Line 2 - Duplicate column name 'notes' Line 3 - Duplicate column name 'suspendproduct' 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 '\'\', \'admin\', \'Escalation Rule Notification\', \'[Ticket ID: {$tickettid}] E' at line 1 Line 5 - Duplicate column name 'showinvoice' Line 6 - Duplicate column name 'autoterminatedays' 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 '\'GenerateRandomUsername\', \'\')' at line 1 Line 8 - Duplicate column name 'assignedips' Line 9 - Duplicate column name 'proposal' Line 10 - 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 '\'AddFundsRequireOrder\', \'on\')' at line 1 Line 11 - 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 '\'GroupSimilarLineItems\', \'on\')' at line 1 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 '\'ProrataClientsAnniversaryDate\', \'\')' at line 1 Line 13 - 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 '\'TCPDFFont\', \'helvetica\')' at line 1 Line 15 - Duplicate column name 'disabled' Line 16 - Duplicate column name 'attachments' Line 17 - Duplicate column name 'upgrades' 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 '\'CancelInvoiceOnCancellation\', \'on\')' 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 '\'4.5.0\' WHERE setting=\'Version\'' at line 1 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,income_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,income_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 You should now delete the install folder from your web server.

و آپگرید هم نمیکنه :(
چی میگه این ؟ به خاطر این من ورژن مای اسکیول هم آپگرید کردم به 5.5 اما باز این مشکل رو دارم :(

پاسخ : ارور هنگام آپگرید - whmcs بازان بیان تو

فکر کنم اشتباه اپگرید میکنید

چون این پیغام مربوط به زمانی هست که 2 بار کلوم همنام بخواد ایمپورت بشه

پاسخ : ارور هنگام آپگرید - whmcs بازان بیان تو

نقل قول:

نوشته اصلی توسط allbert

فکر کنم اشتباه اپگرید میکنید

چون این پیغام مربوط به زمانی هست که 2 بار کلوم همنام بخواد ایمپورت بشه

والا من دیتابیس رو پاک میکنم دوباره میریزم و بکاپ دیتا بیس قبلی رو برمیگردونم بخوام آپگرید کنم باز این مشکل هست :(
؟

---------- Post added at 07:30 PM ---------- Previous post was at 06:23 PM ----------

یکی ما را یاری کنه :d

پاسخ : ارور هنگام آپگرید - whmcs بازان بیان تو

strict mode را غیر فعال کرده و دوباره امتحان کنید.
برای غیر فعال کردن میتونید از طریق SSH و یا خود phpmyadmin اقدام کنید.
از طریق SSH وارد mysql شده و query زیر را اجرا کنید:

کد:

mysql> select @@GLOBAL.sql_mode;

سپس:

کد:

mysql> SET GLOBAL sql_mode="";

و...

کد:

mysql> select @@GLOBAL.sql_mode;

پاسخ : ارور هنگام آپگرید - whmcs بازان بیان تو

باز نشد :( همان ارورها:(