Em Andamento

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:

1064

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

Ver 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, fix website database error, joomla server error, database joomla content, database content joomla, order line joomla, 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, joomla manual component, copying sql database, fix mysql joomla

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

ID do Projeto: #6826579

Premiar a:

devd22

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 Avaliações)
4.9

5 freelancers estão ofertando em média $25 para este trabalho

EDICIG

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)
1.0
Mufaddalsaifee

Hi, Thanks for posting this project I have 3+ years of experience in SQL, MySQL, excel(VBA coding) and VB.net I have fully read your details and will be available for you on skype (muff.saif9036) for voice chat. Ple Mais

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

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)
0.0
chandranath19

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)
0.0