Fix 1064 MYSQL Database Error

I'm migrating a Joomla website but after copying the database of a component called K2 I'm receiving this error:


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 ') ORDER BY [url removed, login to view] DESC LIMIT 0' at line 12 SQL=SELECT [url removed, login to view] AS id FROM xxxxx_k2_items AS content WHERE [url removed, login to view] = 1 AND [url removed, login to view] = 0 AND [url removed, login to view] IN (1,1,2,3,4,5,6,7) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2014-12-05 05:03:48' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2014-12-05 05:03:48' ) AND ( ) ORDER BY [url removed, login to view] DESC LIMIT 0,15;

Habilidades: Administração de Bancos de Dados, MySQL, SQL

Veja mais: sql syntax error, sql select order, mysql sql syntax, fix joomla database, sql syntax, error 1064, migrating sql server mysql, sql error 1064 mysql, joomla server mysql server, fix website database error, joomla server error, database joomla content, database content joomla, sql database joomla, order line joomla, joomla k2 component, joomla database version, fix sql error, fix mysql database, fix joomla sql, check limit mysql database, sql database error, copying joomla website, copying database website, syntax error line joomla

Acerca do Empregador:
( 24 comentários ) Sao Paulo, Brazil

ID do Projeto: #6826579

Concedido a:


Hi, I am interested in this project. Just check my review of work and give me an opportunity to prove myself. Please consider my bid. Thanks & Regards Dev

$25 USD em 1 dia
(77 Comentários)

5 freelancers are bidding on average $25 for this job


Hello. I am ready to get the query to be checked. All my clients is satisfied with the result. I hope That you Will Remain satisfied, and WE Will work in the future. Waiting for a positive response. Regards Eugene.

$15 USD em 1 dia
(1 Comentário)

Hi, Thanks for posting this project I have 3+ years of experience in SQL, MySQL, excel(VBA coding) and I have fully read your details and will be available for you on skype ([url removed, login to view]) for voice chat. Ple Mais

$35 USD in 3 dias
(2 Comentários)

Hi, It is highly appreciate to come on chat so we can proceed and solve the your problem. Thanks

$25 USD em 1 dia
(1 Comentário)

Hello sir, Can you please send that particular table with its data & specify the particular requirements you want to access from the table...I will provide you the necessary SQL code without error,that might work fine Mais

$23 USD em 1 dia
(0 Comentários)