SQL Erorr massage

[eyalher]

Hi,

When I want to save a "list" I got this massage:

SQL=ALTER TABLE `bikes` CHANGE `id` `id` int(11) NOT NULL AUTO_INCREMENT


What I need to do?

Eyal

 

[woznyp]

Hi eyalher
can you post screenshot and describe situation (because you can save new list or exsiting).

// Usually when you are trying to change filed type, Fabrik changes that filed type in DB.

 

[eyalher]

Hi woznyp ,

I got one table (bikes) and 5 lists for that table.
when I want tho change something I got this massage and nothing change.

attachment the screenshot

 

[Sophist]

Hmmm - interesting! The 0 at the beginning of the message is a return code - and a return code of 0 normally means success.

Do you have access to myphpadmin to go and look at the structure of the bikes table and tell us (or better still post a screen shot) what the table structure is, perhaps before and after you get this error.

Also, are you on the latest GitHub - if not can you update and retest.

Thx.

S

P.S. It could be something about having multiple lists pointing to a single table - which I think means multiple elements pointing to the id field. If some of them are not internalid elements, then I could see there being changes made to the column definition when you edit them.

 

[woznyp]

eyalher can you turn on debug in Joomla! and show us some additional information?

 

[eyalher]

hi ,

thanks for the help !

I deleted the table and started from new and now its o.k

 

[troester]

You can close thread with "Thread Tools" above (uncheck "open")