COMMUNITY FORUM

Keyword
  1. Forum
  3. Search

Advanced Search

Search Results (Searched for: Re Error SQL)

  • stas
  • stas's Avatar
16 Aug 2017 19:52
Replied by stas on topic Error voting for the article

Error voting for the article

Category: English K2 Community

Here's the actual 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 '' at line 3
  • thanos
  • thanos's Avatar
21 Jul 2017 11:25
Cant open K2 items 1064 error was created by thanos

Cant open K2 items 1064 error

Category: English K2 Community

Hello ,

i noticed after i upgraded to 3.7.3 i cannot open any K2 items even though i can see them in modules and categories i get 1064 error

ERROR 1064
"YOU HAVE AN ERROR IN YOUR SQL SYNTAX; CHECK THE MANUAL THAT CORRESPONDS TO YOUR MARIADB SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR ':PAROSTESTEE' AT LINE 1 "

where parostestee is the name of the item

URL:
discovercyclades.gr/el/naxos/parostestee

i also tried with the latest K2 developper version and disabled all plugins on K2 ITEM pages

thank you
  • Ljubo Jurošević
  • Ljubo Jurošević's Avatar
19 Jul 2017 00:58 - 19 Jul 2017 01:02
Replied by Ljubo Jurošević on topic Error with dates in Joomla 3.7.3

Error with dates in Joomla 3.7.3

Category: English K2 Community

Maybe, its same reason for my probleme here to: www.joomlaworks.net/forum/k2-en/48006-sql-1064#162953 with k2 modules, also give error with dates order... IDK
  • Ljubo Jurošević
  • Ljubo Jurošević's Avatar
18 Jul 2017 02:01
sql 1064 was created by Ljubo Jurošević

sql 1064

Category: English K2 Community

Hello,
Im owner of www.pr0gamers.net and everythings works fine (I think). But, whenever I install some extensions (helix 3) like slide show pro sp2 or news show sp2 (etc), on LT game free template, I got 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 ') AND a.featured != 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up' at line 1

Thank You.
  • noya
  • noya's Avatar
16 Jul 2017 14:01
Joomla Database Error was created by noya

Joomla Database Error

Category: English K2 Community

Hi every body,

I asked this question on other fora already but without any help.
I'm using Joomla as a CMS and the site was working well till I changed my SQL password that were working well but my site stopped working.
I don't know the old password, so I upgraded to a new version of joomla but without success.
I'm almost lost my website, tone of contents and hours of writing.

Please someone help me to get the site working again.
Your helps are appreciated.
  • wintercorn
  • wintercorn's Avatar
07 Jul 2017 16:00
Double timezone specification error was created by wintercorn

Double timezone specification error

Category: English K2 Community

Joomla - 3.7.3 Stable
Joomla Platform - 13.1.0 Stable
K2 - 2.7.1
php - 5.6.30-1~dotdeb+7.1
mysql - 5.5.55-0+deb7u1

I know there's another thread on this subject but that wasn't resolved and I wanted to flag this issue up. We have a site where when creating a new K2 item and clearing the Creation Date field stores the date as 30/11/-0001 - 00:00. Saving that item results in the following error:

DateTime::__construct(): Failed to parse time string (-1-11-30 00:00:00) at position 5 (-): Double timezone specification

Server, site and user timezones are set to UTC.

I've tried this with different users with no difference.

Any suggestions?

Thanks
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
22 Jun 2017 17:45
Replied by Krikor Boghossian on topic 1064 You have an error in your SQL syntax;

1064 You have an error in your SQL syntax;

Category: English K2 Community

You 're welcome :)
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
21 Jun 2017 13:52
Replied by Krikor Boghossian on topic 1064 You have an error in your SQL syntax;

1064 You have an error in your SQL syntax;

Category: English K2 Community

Unfortunately you will have to refer this issue to the extension's developers.
  • tednikos
  • tednikos's Avatar
21 Jun 2017 13:24
Replied by tednikos on topic 1064 You have an error in your SQL syntax;

1064 You have an error in your SQL syntax;

Category: English K2 Community

When i deactivate the Additional Categories for K2 there is no problem with the new articles. The case is i need this plugin. Any solution? :)
  • tednikos
  • tednikos's Avatar
21 Jun 2017 13:18
Replied by tednikos on topic 1064 You have an error in your SQL syntax;

1064 You have an error in your SQL syntax;

Category: English K2 Community

I use K2 v2.7.1 version and Additional Categories for K2 version1.0.1
The template is SJ Directory Free Version quick start package.
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
21 Jun 2017 13:01
Replied by Krikor Boghossian on topic 1064 You have an error in your SQL syntax;

1064 You have an error in your SQL syntax;

Category: English K2 Community

Which version of K2 are you using?
Furthermore are you using any K2 related extensions?
  • tednikos
  • tednikos's Avatar
21 Jun 2017 12:43
1064 You have an error in your SQL syntax; was created by tednikos

1064 You have an error in your SQL syntax;

Category: English K2 Community

When i 'm going to create a new item (article) i take this message: "1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')}' at line 1"
Can you help me please?
This is a screenshot: www.dropbox.com/s/ri3xkz156zntkcc/error-1064.jpg?dl=0
  • Eduard Dimitrov
  • Eduard Dimitrov's Avatar
20 Jun 2017 13:05 - 20 Jun 2017 13:34
Replied by Eduard Dimitrov on topic Show K2 extra field data in external component like K2Store

Show K2 extra field data in external component like K2Store

Category: English K2 Community

Krikor, thanks, but is not workig for specific K2Store pages (pages are outside K2) - there is no fields data in foreach.

var_dump($item) show me this:
object(TableOrderItems)#489 (30) { ["_tbl":protected]=> string(21) "#__k2store_orderitems" ["_tbl_key":protected]=> string(12) "orderitem_id" ["_tbl_keys":protected]=> array(1) { [0]=> string(12) "orderitem_id" } ["_db":protected]=> object(JDatabaseDriverMysqli)#15 (23) { ["name"]=> string(6) "mysqli" ["serverType"]=> string(5) "mysql" ["connection":protected]=> object(mysqli)#16 (19) { ["affected_rows"]=> int(1) ["client_info"]=> string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $" ["client_version"]=> int(50012) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(0) ["error"]=> string(0) "" ["error_list"]=> array(0) { } ["field_count"]=> int(5) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(10) "5.5.52-cll" ["server_version"]=> int(50552) ["stat"]=> string(158) "Uptime: 8336177 Threads: 36 Questions: 5457298976 Slow queries: 4574 Opens: 25842187 Flush tables: 1 Open tables: 32768 Queries per second avg: 654.652" ["sqlstate"]=> string(5) "00000" ["protocol_version"]=> int(10) ["thread_id"]=> int(72258564) ["warning_count"]=> int(0) } ["nameQuote":protected]=> string(1) "`" ["nullDate":protected]=> string(19) "0000-00-00 00:00:00" ["_database":"JDatabaseDriver":private]=> string(14) "jozitrad_newww" ["count":protected]=> int(61) ["cursor":protected]=> NULL ["debug":protected]=> bool(false) ["limit":protected]=> int(0) ["log":protected]=> array(0) { } ["timings":protected]=> array(0) { } ["callStacks":protected]=> array(0) { } ["offset":protected]=> int(0) ["options":protected]=> array(9) { ["driver"]=> string(6) "mysqli" ["host"]=> string(9) "localhost" ["user"]=> string(14) "jozitrad_newww" ["password"]=> string(12) "removedddd" ["database"]=> string(14) "jozitrad_newww" ["prefix"]=> string(6) "ejkb4_" ["select"]=> bool(true) ["port"]=> int(3306) ["socket"]=> NULL } ["sql":protected]=> string(177) "SELECT i.id,i.alias,i.code,i.catid,c.alias AS categoryalias FROM #__k2_items as i LEFT JOIN #__k2_categories c ON c.id = i.catid WHERE i.published =1 AND i.id='9928481'" ["tablePrefix":protected]=> string(6) "ejkb4_" ["utf":protected]=> bool(true) ["utf8mb4":protected]=> bool(true) ["errorNum":protected]=> int(0) ["errorMsg":protected]=> string(0) "" ["transactionDepth":protected]=> int(0) ["disconnectHandlers":protected]=> array(0) { } } ["_trackAssets":protected]=> bool(false) ["_rules":protected]=> NULL ["_locked":protected]=> bool(false) ["_autoincrement":protected]=> bool(true) ["_observers":protected]=> object(JObserverUpdater)#493 (2) { ["observers":protected]=> array(0) { } ["doCallObservers":protected]=> bool(true) } ["_columnAlias":protected]=> array(0) { } ["_jsonEncode":protected]=> array(0) { } ["_errors":protected]=> array(1) { [0]=> string(0) "" } ["orderitem_id"]=> int(135) ["order_id"]=> int(1497952376) ["product_id"]=> string(7) "9928481" ["orderitem_attributes"]=> string(2) "{}" ["orderitem_attribute_names"]=> string(2) "{}" ["orderitem_sku"]=> string(17) "11111111222222222" ["orderitem_name"]=> string(34) "Нов тестов продукт" ["orderitem_quantity"]=> int(1) ["orderitem_price"]=> float(0) ["orderitem_attributes_price"]=> int(0) ["orderitem_discount"]=> NULL ["orderitem_final_price"]=> float(0) ["orderitem_tax"]=> int(0) ["orderitem_shipping"]=> NULL ["orderitem_shipping_tax"]=> NULL ["orderitem_status"]=> NULL ["modified_date"]=> string(19) "2017-06-20 09:52:56" ["_isNew"]=> bool(true) }
  • Javier Romero
  • Javier Romero's Avatar
31 May 2017 14:25
Replied by Javier Romero on topic Image upload error K2.7 and J3.5

Image upload error K2.7 and J3.5

Category: English K2 Community

Mailson Anselmo wrote: I have the same problem.


The image does not appear and displays the message "
Image not uploaded. Please make sure that you have used a valid image file and that the file upload is configured accordingly on your server".

I use J 3.7, PHP 5.4.16 and K2 2.7.1

Information system
Web server Apache / 2.4.6 (Red Hat Enterprise Linux) OpenSSL / 1.0.1e-fips PHP / 5.4.16
PHP version 5.4.16
MySQL version 5.5.52-MariaDB
GD Picture Library Disabled
Multibyte string support Able
Upload limit 100M
Memory limit 256M
Open remote files (allow url fopen) Yes

Need HELP.


After update to J 3.7.2 and K2 2.7.1 we have the same problem

We update to k2 2.8.0 and not working in php 5.6 o php 7.0

We just install php-gd and it works in all versions

K2 2.7.1 + Php 5.6 OK
K2 2.7.1 + Php 7.0 OK
K2 2.8.0 + Php 5.6 OK
K2 2.8.0 + Php 7.0 OK

Try to install php5-gd or php7.0-gd, it works for us
  • John
  • John's Avatar
25 May 2017 13:57 - 25 May 2017 13:58
Replied by John on topic Error on Save with K2 and php 7.1.x

Error on Save with K2 and php 7.1.x

Category: English K2 Community

Hello Krikor,

I just found out that it is only happening on 1 of my sites from 5-6 that use K2 all others are saving fine.
All sites have K2 v2.7.2 Dev Build (github.com/getk2/k2)

The only difference that i can remember about the problematic site is that i had upgraded to Dev Build on version K2 2.7.0 (i did update to K2 v2.7.2 Dev Build since then).
Plus that i have changed to 3 letters sql querries (don't know if it's relative).
  • Mailson Anselmo
  • Mailson Anselmo's Avatar
05 May 2017 17:49
Replied by Mailson Anselmo on topic Image upload error K2.7 and J3.5

Image upload error K2.7 and J3.5

Category: English K2 Community

I have the same problem.


The image does not appear and displays the message "
Image not uploaded. Please make sure that you have used a valid image file and that the file upload is configured accordingly on your server".

I use J 3.7, PHP 5.4.16 and K2 2.7.1

Information system
Web server Apache / 2.4.6 (Red Hat Enterprise Linux) OpenSSL / 1.0.1e-fips PHP / 5.4.16
PHP version 5.4.16
MySQL version 5.5.52-MariaDB
GD Picture Library Disabled
Multibyte string support Able
Upload limit 100M
Memory limit 256M
Open remote files (allow url fopen) Yes

Need HELP.
  • Gianfranco
  • Gianfranco's Avatar
19 Apr 2017 12:41
Invalid backend response. Data is not JSON. was created by Gianfranco

Invalid backend response. Data is not JSON.

Category: Comunità italiana K2

Ciao a tutti, ho riscontrato il seguente errore: "Invalid backend response. Data is not JSON.", di solito ottimizzavo il php.ini dal pannello di controllo del mio hosting adesso non lo fa fare più, nel senso che non si può ottimizzare perchè è già predisposto ed io non riesco a sistemare questo errore, qualcuno può aiutarmi? Grazie mille in anticipo.
Seguono le caratteristiche del sistema:
Versione Joomla (Hai già l'ultima versione di Joomla, la 3.4.1)
Versione K2 2.7.2
Informazioni di sistema

Server web Apache
Versione PHP 5.6.30
Versione MySQL 5.5.54-38.6-log
Libreria GD per le immagini bundled (2.1.0 compatible)
Supporto alle stringhe multibyte Abilitato
Limite del caricamento 25M
Limite di memoria 256M
Apri i files remoti (abilita url fopen) Sì
  • Kieron Novak
  • Kieron Novak's Avatar
07 Apr 2017 11:15
Replied by Kieron Novak on topic Database issue.

Database issue.

Category: English K2 Community

Hello. This is the error:

jDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')}' at line 1 SQL=DELETE FROM jos_k2_tags_xref WHERE itemID={intval()}
  • Kieron Novak
  • Kieron Novak's Avatar
06 Apr 2017 07:30
Database issue. was created by Kieron Novak

Database issue.

Category: English K2 Community

Suddenly i am facing with this issue. When i am trying to save a new article i see the below msg and nothing is getting save.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 6 SQL=UPDATE jos_k2_items SET video_caption = '', video_credits = '', extra_fields = '[]', extra_fields_search = '' , published = '1' WHERE id =

This is on joomla 1.5.22
  • Marco Antonio “Tirrel Cinsel Kizkaciran” Gonzalez Ortiz
  • Marco Antonio “Tirrel Cinsel Kizkaciran” Gonzalez Ortiz's Avatar
08 Mar 2017 21:47
Error imposible publicar en K2: TableK2Item: :almacenamiento was created by Marco Antonio “Tirrel Cinsel Kizkaciran” Gonzalez Ortiz

Error imposible publicar en K2: TableK2Item: :almacenamiento

Category: Comunidad hispana oficial de K2

Hola buenos días a todos.

Agradezco de antemano y espero puedan ayudarme, he perdido la capacidad de crear artículos en K2 de Joomla, al tratar de hacer un artículo, regresa el siguiente error:


TableK2Item: :almacenamiento fallido
Table './codigo75/zdfs_k2_items' is marked as crashed and last (automatic?) repair failed SQL=INSERT INTO `zdfs_k2_items` (`id`,`title`,`alias`,`catid`,`published`,`introtext`,`fulltext`,`image_caption`,`image_credits`,`video_caption`,`video_credits`,`created`,`created_by`,`created_by_alias`,`publish_up`,`publish_down`,`access`,`ordering`,`featured`,`metadata`,`metadesc`,`metakey`,`params`,`language`) VALUES ('','hola','hola','1','1','

hola-test
','','','','','','2017-03-09 03:47:25','83','','2017-03-09 03:47:25','0000-00-00 00:00:00','1','','0','robots=\nauthor=','','','{\"catItemTitle\":\"\",\"catItemTitleLinked\":\"\",\"catItemFeaturedNotice\":\"\",\"catItemAuthor\":\"\",\"catItemDateCreated\":\"\",\"catItemRating\":\"\",\"catItemImage\":\"\",\"catItemIntroText\":\"\",\"catItemExtraFields\":\"\",\"catItemHits\":\"\",\"catItemCategory\":\"\",\"catItemTags\":\"\",\"catItemAttachments\":\"\",\"catItemAttachmentsCounter\":\"\",\"catItemVideo\":\"\",\"catItemVideoWidth\":\"\",\"catItemVideoHeight\":\"\",\"catItemAudioWidth\":\"\",\"catItemAudioHeight\":\"\",\"catItemVideoAutoPlay\":\"\",\"catItemImageGallery\":\"\",\"catItemDateModified\":\"\",\"catItemReadMore\":\"\",\"catItemCommentsAnchor\":\"\",\"catItemK2Plugins\":\"\",\"itemDateCreated\":\"\",\"itemTitle\":\"\",\"itemFeaturedNotice\":\"\",\"itemAuthor\":\"\",\"itemFontResizer\":\"\",\"itemPrintButton\":\"\",\"itemEmailButton\":\"\",\"itemSocialButton\":\"\",\"itemVideoAnchor\":\"\",\"itemImageGalleryAnchor\":\"\",\"itemCommentsAnchor\":\"\",\"itemRating\":\"\",\"itemImage\":\"\",\"itemImgSize\":\"\",\"itemImageMainCaption\":\"\",\"itemImageMainCredits\":\"\",\"itemIntroText\":\"\",\"itemFullText\":\"\",\"itemExtraFields\":\"\",\"itemDateModified\":\"\",\"itemHits\":\"\",\"itemCategory\":\"\",\"itemTags\":\"\",\"itemAttachments\":\"\",\"itemAttachmentsCounter\":\"\",\"itemVideo\":\"\",\"itemVideoWidth\":\"\",\"itemVideoHeight\":\"\",\"itemAudioWidth\":\"\",\"itemAudioHeight\":\"\",\"itemVideoAutoPlay\":\"\",\"itemVideoCaption\":\"\",\"itemVideoCredits\":\"\",\"itemImageGallery\":\"\",\"itemNavigation\":\"\",\"itemComments\":\"\",\"itemTwitterButton\":\"\",\"itemFacebookButton\":\"\",\"itemGooglePlusOneButton\":\"\",\"itemAuthorBlock\":\"\",\"itemAuthorImage\":\"\",\"itemAuthorDescription\":\"\",\"itemAuthorURL\":\"\",\"itemAuthorEmail\":\"\",\"itemAuthorLatest\":\"\",\"itemAuthorLatestLimit\":\"\",\"itemRelated\":\"\",\"itemRelatedLimit\":\"\",\"itemRelatedTitle\":\"\",\"itemRelatedCategory\":\"\",\"itemRelatedImageSize\":\"\",\"itemRelatedIntrotext\":\"\",\"itemRelatedFulltext\":\"\",\"itemRelatedAuthor\":\"\",\"itemRelatedMedia\":\"\",\"itemRelatedImageGallery\":\"\",\"itemK2Plugins\":\"\"}','*')
Displaying 81 - 100 out of 789 results.
  1. Forum
  3. Search

Powered by Kunena Forum