Help- SQL error after migration j1.5->j2.5

gydi

New Member
After migration from j1.5 -> j2.5.11 and fabrik 3.08 when changing table row (list) in front-end of joomla and save changes gives an error:
Code:
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 '' at line 1 SQL=UPDATE `jos__fb_contact_sample` SET `upload_image`='',`Sity`='??????',`avatar`='/AA_logo.jpg',`first_name`='????',`last_name`='??????',`phone`='0878762007',`nikname`='',`email`='',`date_time`='2011-05-04 00:00:00',`message`='' WHERE

Is the id element (fab_animal___id) published, writable, set as primary key in your list settings?

Table name jos__fb_contact_sample
How and where do I check if I have primary key, and if I do not how to do it?

Code:
http://hwork25.sabev-bg.com/bg/chlenove
PHP Built On Linux iris.superhosting.bg 2.6.32-379.14.1.lve1.1.9.9.el6.x86_64 #1 SMP Thu Dec 6 07:12:24 EST 2012 x86_64
Database Version 5.5.28-cll
Database Collation utf8_general_ci
PHP Version 5.3.14
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 2.5.11 Stable [ Ember ] 26-April-2013 14:00 GMT
 
Can you post the complete error message?
Did you try to create a new list (not using the old contact_sample)?
 
Can you post the complete error message?


Did you try to create a new list (not using the old contact_sample)?

I will try.
**********************************edit
All is well!
Id (No) migrate trash.
Id->Publish Item->unpublish->Publish Item
Jomla->maintenance->clear ,purge cache
Jomla->maintenance->global sheck-in
Jomla->maintenance->clear ,purge cache

thank you troester for:
troester said: ?
Is the id element (fab_animal___id) published, writable, set as primary key in your list settings?
 

Attachments

  • sqlerror.JPG
    sqlerror.JPG
    48.9 KB · Views: 135
  • sqlerror2.JPG
    sqlerror2.JPG
    48.8 KB · Views: 130
  • sqlerror_J15_primay_key.JPG
    sqlerror_J15_primay_key.JPG
    219.8 KB · Views: 137
  • sqlerror_J25_primay_key_Migrate_Trash.JPG
    sqlerror_J25_primay_key_Migrate_Trash.JPG
    141.8 KB · Views: 134
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top