Editing records not working after 1.0.4

[Illus]

Hello!

I have 'simple' tables based on same formdata. After updating to 1.0.4 I can't edit records any more. Adding records goes just fine. All editing is done as a super admin. When saving the edit form I get this:

""
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 rth_fabrik_formdata_18 SET `kohde`=\'As Oy Oulun Erauspoika\',`talo`=\'B\',`krs`=\'1\',`hsto`=\'B5|http://rakennustehofi.virtual31.nebula.fi/index.php?option=com_content&task=view&id=203&Itemid=115\',`hstotyyppi`=\'3h+k+s\',`koko`=\'65\',`myyntihinta`=\'50700\',`lainaosuus`=\'76100\',`kokonaishinta`=\'126800\',`tila`=\'Vapaa\' WHERE
""

And that's it. Joomla system info says:

PHP built On: Linux virtual31.nebula.fi 2.6.18-1.2849.fc6 #1 SMP Fri Nov 10 12:45:28 EST 2006 i686
Database Version: 5.0.22
PHP Version: 5.1.6
Web Server: Apache/2.2.3 (Fedora)
WebServer to PHP interface: cgi-fcgi
Joomla! Version: Joomla! 1.0.12 Stable [ Sunfire ] 25 December 2006 01:00 UTC
User Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fi; rv:1.8.1.4) Gecko/20070515 Firefox/2.0.0.4
Relevant PHP Settings:
Joomla! Register Globals Emulation: OFF
Register Globals: OFF
Magic Quotes: OFF
Safe Mode: OFF
File Uploads: ON
Session auto start: OFF
Session save path: /tmp
Short Open Tags: ON
Output Buffering: OFF
Open basedir: none
Display Errors: ON
XML enabled: Yes
Zlib enabled: Yes
Disabled Functions: none
Configuration File: <?php
$mosConfig_MetaAuthor = '1';
$mosConfig_MetaDesc = '';
$mosConfig_MetaKeys = '';
$mosConfig_MetaTitle = '1';
$mosConfig_absolute_path = '/var/www/customers/...;
$mosConfig_admin_expired = '1';
$mosConfig_allowUserRegistration = '0';
$mosConfig_back_button = '1';
$mosConfig_cachepath = '/var/www/customers/...';
$mosConfig_cachetime = '900';
$mosConfig_caching = '0';
$mosConfig_db = 'xxxxxx'
$mosConfig_dbprefix = 'rth_';
$mosConfig_debug = '0';
$mosConfig_dirperms = '';
$mosConfig_editor = 'jce';
$mosConfig_enable_log_items = '0';
$mosConfig_enable_log_searches = '0';
$mosConfig_enable_stats = '0';
$mosConfig_error_message = 'This site is temporarily unavailable.
Please notify the System Administrator';
$mosConfig_error_reporting = '-1';
$mosConfig_favicon = 'favicon.ico';
$mosConfig_fileperms = '';
$mosConfig_fromname = '';
$mosConfig_frontend_login = '1';
$mosConfig_frontend_userparams = '1';
$mosConfig_gzip = '0';
$mosConfig_helpurl = 'http://help.joomla.org';
$mosConfig_hideAuthor = '1';
$mosConfig_hideCreateDate = '1';
$mosConfig_hideEmail = '1';
$mosConfig_hideModifyDate = '1';
$mosConfig_hidePdf = '1';
$mosConfig_hidePrint = '0';
$mosConfig_hits = '0';
$mosConfig_host = 'xxxxxx'
$mosConfig_icons = '1';
$mosConfig_item_navigation = '0';
$mosConfig_lang = 'finnish';
$mosConfig_lifetime = '1000';
$mosConfig_link_titles = '0';
$mosConfig_list_limit = '50';
$mosConfig_live_site = '.....;
$mosConfig_locale = 'fi_FI';
$mosConfig_mailer = 'mail';
$mosConfig_mailfrom = '......';
$mosConfig_multilingual_support = '0';
$mosConfig_multipage_toc = '1';
$mosConfig_offline = '1';
$mosConfig_offline_message = 'Sivustoa huolletaan parasta aikaa.
Vieraile myöhemmin uudelleen.';
$mosConfig_offset = '-1';
$mosConfig_offset_user = '2';
$mosConfig_pagetitles = '1';
$mosConfig_password = 'xxxxxx'
$mosConfig_readmore = '1';
$mosConfig_secret = '......';
$mosConfig_sef = '0';
$mosConfig_sendmail = '/usr/sbin/sendmail';
$mosConfig_session_life_admin = '3000';
$mosConfig_session_type = '0';
$mosConfig_shownoauth = '0';
$mosConfig_sitename = '.......';
$mosConfig_smtpauth = '0';
$mosConfig_smtphost = 'localhost';
$mosConfig_smtppass = '';
$mosConfig_smtpuser = '';
$mosConfig_uniquemail = '1';
$mosConfig_user = 'xxxxxx'
$mosConfig_user = 'xxxxxx'
$mosConfig_vote = '0';
setlocale (LC_TIME, $mosConfig_locale);
?>

 

[lknmedia]

I have the same error.

 

[joaquinjgc]

Try:

If you have a table and a form to wiew and modify details, You have the field "id" and you don´t want that the user could modify it, you must give access to the user level, and enable the "hidden" checkbox in the element configuration. If you deny access to the user level the user will receive a message like the first post.

The order by field in table configuration must be set in other element that isn´t "id" element.