COMMUNITY FORUM

Keyword
  1. Forum
  3. Search

Advanced Search

Search Results (Searched for: Re Error SQL)

  • Simone Wollmann
  • Simone Wollmann's Avatar
02 Nov 2017 18:32
error message was created by Simone Wollmann

error message

Category: English K2 Community

Joomla! 3.8.1
Hikashop 3.2.0

I was in the control panel of Hikashop and tried to edit the window "sales of the month", because it shows nothing, but have orders.
But suddenly I get this error message when I click in the control panel of Hikashop.

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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1

screen: imgur.com/a/mO6F4

What can I do? I need urgently help please.

Thanks in advance
Simone
  • william white
  • william white's Avatar
17 Sep 2017 19:15
Replied by william white on topic Site broken after K2 upgrade

Site broken after K2 upgrade

Category: English K2 Community

Since you dont have a current backup you should probably do a mysql dump of the site just in case of the worst before making other changes.
First try to edit your configuration.php file and turn error reporting to ‘E_ALL | E_STRICT’ and hopefully you may see an error instead of a blank page that may lead you to know what going on.
Later you may need to:
I would unzip the k2 package file and ftp the entire com_k2 directories on top of your exisiting ones and see if that helps
Since it Broke Joomla, you may have to do the same thing with your current version of Joomla as well
but try to find out whats going on first
  • Mr A J Tooze
  • Mr A J Tooze's Avatar
16 Sep 2017 00:39
Site broken after K2 upgrade was created by Mr A J Tooze

Site broken after K2 upgrade

Category: English K2 Community

(Joomla 3.7.5, MySQL 5.6.32)

I upgraded K2 to 2.8.0 yesterday as it the admin page was prompting me to do so. Previous version was 2.6.7. I made the mistake of doing it in a hurry, and foolishly didn't take a full site backup immediately beforehand :-(

The upgrade process completed quickly, but gave the following error messages:

Warning
JFolder: :delete: Path is not a folder. Path: /home1/handsom1/public_html/components/com_k2/js
JFolder: :delete: Path is not a folder. Path: /home1/handsom1/public_html/components/com_k2/sef_ext
Duplicate column name 'ip' SQL=ALTER TABLE `#__k2_users` ADD `ip` VARCHAR( 15 ) NOT NULL , ADD `hostname` VARCHAR( 255 ) NOT NULL , ADD `notes` TEXT NOT NULL
Error
Error installing component

After this, accessing the web site simply returns a blank page (seems to be giving a Server Error 500). The admin login is available, but after authentication just get blank screen again. I tried reverting back to the daily site & DB backup, but this made no difference to the results. I have subsequently reverted back even further, but to no avail.. I have even tried reinstalling the original version of K2, but get a similar SQL error.

On further investigation, it appears that some of the admin pages are available if I enter the full URL directly, such as the list of K2 items, but trying to open an item just gives blank page again. I am unable to use the 'Manage Extensions' dashboard, although the 'Install Extensions' page is available.

What might be broken here, and why is the file restore not fixing it? I have cleared the caches wherever I can.

As I can't access the Global Properties, I cannot switch debug on. How else can I find out what is failing here?

Any help would be much appreciated to get us back on line :-)
  • Eddie May
  • Eddie May's Avatar
18 Aug 2017 19:13 - 18 Aug 2017 19:16
K2 2.8 Fatal Error was created by Eddie May

K2 2.8 Fatal Error

Category: English K2 Community

Hi,
Upgraded K2 this afternoon & am now getting the following when creating/editing a K2 item

Fatal error: Cannot declare class upload, because the name is already in use in /home/...../public_html/administrator/components/com_k2/lib/class.upload.php on line 624

Joomla! Info:
PHP Version 7.0.22
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.7.5 Stable [ Amani ] 14-August-2017 12:09 GMT

MySQL version 5.6.36-82.1-log
GD image library bundled (2.1.0 compatible)
Multibyte string support Enabled
Upload limit 128M
Memory limit 768M
Open remote files (allow url fopen) Yes

Any suggestions?

Thanks,
Eddie
  • 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.
Displaying 81 - 100 out of 793 results.
  1. Forum
  3. Search

Powered by Kunena Forum