Page 1 of 1

An error has occurred SQL=INSERT INTO

Posted: Mon Feb 08, 2016 12:42 pm
by sahbax6
Hello dear friends
I faced a problem when I wanted update my joomla website

0 SQL=INSERT INTO `f1bz4_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`detailsurl`,`infourl`,`extra_query`) VALUES

('1','700','Joomla','','joomla','file','','0','3.4.8','http://update.joomla.org/core/sts/extension_sts.xml','','')

what is this and how can I fix it ??? ??? ??? ???
Thanks

Re: An error has occurred SQL=INSERT INTO

Posted: Tue Feb 09, 2016 11:21 am
by itoctopus
Checking the query, it seems that the number of the fields correspond (so you're not missing a field in the VALUES list), but the cause can be many other different issues:

- Missing field(s) in the table `updates`
- Trying to insert a row with the same update_site_id
- Other issues

I suggest you check the MySQL error log (which should be under /var/logs/mysql ) to see what the error is. If you don't have access it to that file, then a good idea would be to ask your host to email you the errors (in that file) relevant to your database.

Hope this helps!

Re: An error has occurred SQL=INSERT INTO

Posted: Wed Nov 29, 2017 8:27 pm
by TCoder
I count the same number of fields and values - so that's not the issue.

You should try running that query directly against the database and see what error it tosses.