PDA

توجه ! این یک نسخه آرشیو شده میباشد و در این حالت شما عکسی را مشاهده نمیکنید برای مشاهده کامل متن و عکسها بر روی لینک مقابل کلیک کنید : ارور هنگام آپگرید - whmcs بازان بیان تو



makh000f
April 18th, 2012, 18:35
من میخوام 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,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
You should now delete the install folder from your web server.



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

allbert
April 18th, 2012, 18:46
فکر کنم اشتباه اپگرید میکنید

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

makh000f
April 18th, 2012, 20:30
فکر کنم اشتباه اپگرید میکنید

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

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

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

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

fara_server
April 18th, 2012, 20:42
strict mode را غیر فعال کرده و دوباره امتحان کنید.
برای غیر فعال کردن میتونید از طریق SSH و یا خود phpmyadmin اقدام کنید.
از طریق SSH وارد mysql شده و query زیر را اجرا کنید:


mysql> select @@GLOBAL.sql_mode;
سپس:


mysql> SET GLOBAL sql_mode="";
و...




mysql> select @@GLOBAL.sql_mode;

makh000f
April 19th, 2012, 02:12
باز نشد :( همان ارورها:(