COMMUNITY FORUM

Keyword
  1. Forum
  3. Search

Advanced Search

Search Results (Searched for: Re Error SQL)

  • laurent MARCILLY
  • laurent MARCILLY's Avatar
05 Oct 2015 18:59
Error 1064 on user pages was created by laurent MARCILLY

Error 1064 on user pages

Category: English K2 Community

Hi,
i have 1064 error with K2 2.6.9 and Joomla 3.4.4 and MySQL 5.1 , just after adding an item in K2 :

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 'DESC LIMIT 0,9' AT LINE 20 SQL=SELECT CONTENT.ID AS ID FROM Y3ES2_K2_ITEMS AS CONTENT WHERE CONTENT.PUBLISHED = 1 AND CONTENT.TRASH = 0 AND CONTENT.ACCESS IN (1,1) AND ( CONTENT.PUBLISH_UP = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_UP <= '2015-10-05 17:53:04' ) AND ( CONTENT.PUBLISH_DOWN = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_DOWN >= '2015-10-05 17:53:04' ) AND ( CONTENT.CATID = 4 ) ORDER BY CONTENT. DESC LIMIT 0,9;

read articles about ké errors in user page, bur don't know wich file in my case to modify ...
  • Bob
  • Bob's Avatar
28 Sep 2015 01:15
Replied by Bob on topic error in joomla "tag" page

error in joomla "tag" page

Category: AllVideos

Hi, here's some more info that may lead to an answer.

My live site is broken, so I made a copy and loaded it on MAMP on a local machine. It was also broken. After trying a bunch of things, mostly turning off everything I could get away with, and cleaning up some old data from the live site I exported a new MySQL dump of the live site database and loaded it into my local version. Now the local version was working! I hopefully tried wiping and re-uploading to the live server using the same MySQL dump but it didn't fix the live version.

The PHP settings are different for the local and the live server. I'm attaching the specs for each, labeling one Broken and the other Working to see if any clues can be found there.

The broken one is using PHP 5.5.27 and the working one on MAMP is using 5.5.26 but also works with 5.6.10

dl.dropboxusercontent.com/u/4014332/Broken.pdf
dl.dropboxusercontent.com/u/4014332/Working.pdf
  • Hadi Hemanda
  • Hadi Hemanda's Avatar
21 Sep 2015 13:11
Saving New K2 Item always return 404 - Category Not Found was created by Hadi Hemanda

Saving New K2 Item always return 404 - Category Not Found

Category: English K2 Community

Dear all,

As subject....
it happens just recently.

Additional information :
Web Server : Apache
PHP version : 5.4.40
mySQL version : 5.6.23
K2 version : 2.6.9
SEF using native Joomla (no plug in) with : SEF Enable and URL Rewriting also enable

I've tried to disable SEF and URL Rewriting but it's also not working (with another 'error'). It'll open Front End Home after saving.

Please help.. thanks in advance
  • MGS Creativa
  • MGS Creativa's Avatar
16 Sep 2015 20:48 - 16 Sep 2015 20:52
Replied by MGS Creativa on topic Featured Ordering not work

Featured Ordering not work

Category: English K2 Community

Hi Krikor, thanks for your support!

I'll try to answer as clear as possible, but if you want to have access to my site backend, feel free to ask.

First of all, I have Joomla 3.4.4 and K2 2.6.9 mysql 5.5.44 PHP 5.5.9 Server Apache/2.4.7

Krikor wrote: How did you encounter this error?

This error arraises because I'm migrating a complete messy website into a new and more professional one, for that, I decided to migrate all contents (huge list by the way) from J! content to K2, so far so good. My site has a particularity, the homepage has to show only featured items and they have to be manually reordered in a regular basis over time. Doing so, I've found that featured items got reordered after manually ordering them.

Krikor wrote: Is the ordering/ feature ordering being saved in the DB cells of the xx_k2_items table?

I think that's not working, in this screenshot i.imgur.com/zKO1c9y.png you can see a query with a lot of items with "featured_ordering" set to 0!, this happened just after I set item id 845 to be the first by manual order, in the screenshot appears at 6th position with "featured_ordering" set to 0!

Krikor wrote: Also, did you check the network tab for the requests and their response?

This screenshot displays request result after set item id 17 first by manual reordering i.imgur.com/vd9iPgB.jpg and this one shows the featured item list after reloading the page after set item id 17 at first by manual reordering i.imgur.com/k5LGXTC.jpg

The request result has a lot of HTML because I have enabled XDebug, but the error is this:

Notice: Array to string conversion in libraries/joomla/filter/input.php on line 201
Call Stack
# Time Memory Function Location
1 0.0003 261904 {main}( ) .../index.php:0
2 0.0395 954184 JApplicationCms->execute( ) .../index.php:47
3 0.0395 954488 JApplicationAdministrator->doExecute( ) .../cms.php:252
4 0.0853 2190992 JApplicationAdministrator->dispatch( ) .../administrator.php:152
5 0.0860 2197368 JComponentHelper::renderComponent( ) .../administrator.php:98
6 0.0873 2209864 JComponentHelper::executeComponent( ) .../helper.php:372
7 0.0878 2228560 require_once( '/var/www/clients/client1/web2/web/residencias/administrator/components/com_k2/k2.php' ) .../helper.php:392
8 0.0954 2322608 K2HelperPermissions::checkPermissions( ) .../k2.php:39
9 0.0954 2322920 JRequest::getInt( ) .../permissions.j16.php:26
10 0.0954 2323064 JRequest::getVar( ) .../request.php:193
11 0.0954 2323320 JRequest::_cleanVar( ) .../request.php:152
12 0.0954 2323320 JFilterInput->clean( ) .../request.php:553



I think it's a K2 bug, because I'm expecting featured item list manual reordering to behave as Joomla! featured item list

If you need something else, just ask
  • Alexander Ioannidis
  • Alexander Ioannidis's Avatar
10 Sep 2015 19:20
Replied by Alexander Ioannidis on topic Got PHP 5.3.27 and MySQL 4.1.22, is K2 2.6.7 ok with this?

Got PHP 5.3.27 and MySQL 4.1.22, is K2 2.6.7 ok with this?

Category: English K2 Community

Fatal error: Call to undefined function mb_regex_encoding() in /home/ksports/public_html/components/com_k2/helpers/route.php on line 94

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
10 Sep 2015 19:19
Replied by Krikor Boghossian on topic Got PHP 5.3.27 and MySQL 4.1.22, is K2 2.6.7 ok with this?

Got PHP 5.3.27 and MySQL 4.1.22, is K2 2.6.7 ok with this?

Category: English K2 Community

Enable error reporting to see the actual issue, and paste it here.
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
10 Sep 2015 18:44
Replied by Krikor Boghossian on topic Got PHP 5.3.27 and MySQL 4.1.22, is K2 2.6.7 ok with this?

Got PHP 5.3.27 and MySQL 4.1.22, is K2 2.6.7 ok with this?

Category: English K2 Community

Ok lets administer some CPR then :)
Update to K2 2.6.9
If the issue persists then go to your site's global configuration and enable the error reporting setting, set it to development to see the actual issue.
  • biggleem
  • biggleem's Avatar
10 Sep 2015 16:39
HOW DO I RESOLVE THIS ERROR was created by biggleem

HOW DO I RESOLVE THIS ERROR

Category: English K2 Community

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /home4/wccgfmc1/public_html/libraries/joomla/database/driver/mysqli.php on line 811

THE ERROR WONT ALLOW MW TO ACCESS K2 ITEMS
  • xtipiseto.gr
  • xtipiseto.gr's Avatar
01 Sep 2015 02:00
Installation problem on Joomla 3 was created by xtipiseto.gr

Installation problem on Joomla 3

Category: English K2 Community

I'm trying to install the k2 but is getting error

Table 'lnqizjqj_paid.zkosd_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `zkosd_k2_categories`

I fixed the table following this

and then, next error
Table 'lnqizjqj_paid.zkosd_k2_items' doesn't exist SQL=SHOW FULL COLUMNS FROM `zkosd_k2_items`

What is wrong?
Where is the problem?

Thank you
  • iatriko
  • iatriko's Avatar
31 Aug 2015 21:03
1064 error in extra fields was created by iatriko

1064 error in extra fields

Category: English K2 Community

This error came up when i create extra fields.


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 exf.group, exf.ordering' at line 11 SQL=SELECT exf.*, exfg.name as groupname FROM j25_k2_extra_fields AS exf LEFT JOIN j25_k2_extra_fields_groups exfg ON exf.group=exfg.id WHERE exf.id > 0 AND published = 1 AND (exf.type = 'select' OR exf.type = 'multipleSelect' OR exf.type = 'textfield' OR exf.type = 'radio') AND exf.group = ORDER BY exf.group, exf.ordering


I have v.2.6.9 and joomla 3.4.2
  • Sudhi
  • Sudhi's Avatar
25 Jul 2015 12:46 - 25 Jul 2015 12:55
K2 V3 Error Message on Adding Item or Category was created by Sudhi

K2 V3 Error Message on Adding Item or Category

Category: English K2 Community

New to K2 v3. Installing on Joomla 3.4.3 - and get this error message when I try to add an item or category.
**Uknown error type[1024] Undefined property: K2Categories: id. Line 98 ....**
Screenshot link: i.imgur.com/4ME2lhL.png
Any help to resolve appreciated. Thanks,
Sudhi

System Info
System Information
Name State
Web Server Apache
PHP version 5.6.11
MySQL version 5.5.44-37.3-log
GD image library bundled (2.1.0 compatible)
Upload limit 128M
Memory limit 256M
Open remote files (allow url fopen) Yes
  • peyman
  • peyman's Avatar
24 Jul 2015 16:57 - 24 Jul 2015 16:59
Replied by peyman on topic 1064 Error on Transfer content joomla to k2

1064 Error on Transfer content joomla to k2

Category: English K2 Community

I enable Error report and see:
Notice: Trying to get property of non-object in /home/perspol/public_html/v3/administrator/components/com_k2/models/items.php on line 1224
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 2134 bytes) in /home/perspol/public_html/v3/libraries/joomla/database/driver/mysqli.php on line 811
  • Stuart Brown
  • Stuart Brown's Avatar
23 Jul 2015 14:05
1064 error in K2 module was created by Stuart Brown

1064 error in K2 module

Category: English K2 Community

Hi, apologies for many posts but i'm having a few issues!

This time i have created a K2 Content Module to pull in articles in one category. Everything is fine until I 'show' extra fields, at which point the page which displays the module errors:

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 1 SQL=SELECT id, created_by FROM sgj_k2_items WHERE id=


I have no idea what's happening, but everything is okay when I hide the extra fields again.

Appears we are using a dev version of 2.70.

Any help most appreciated.
  • peyman
  • peyman's Avatar
22 Jul 2015 02:07
1064 Error on Transfer content joomla to k2 was created by peyman

1064 Error on Transfer content joomla to k2

Category: English K2 Community

Hi dears,

i instal joomla and nex k2 v 2.9 on my site, then i need to transfer joomla content to k2 content, but have a error with 1064 name,
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 ' 68534)' at line 1 SQL=INSERT INTO pwu4c_k2_tags_xref (`id`, `tagID`, `itemID`) VALUES (NULL, , 68534)

is thr a way for solv this problem??

Thanks
  • politicaldoubts
  • politicaldoubts's Avatar
20 Jul 2015 00:55
1064 error when trying to create new k2 user page menu item was created by politicaldoubts

1064 error when trying to create new k2 user page menu item

Category: English K2 Community

Hallo to everyone!

Recently i had a new problem on my site. When i tried to create a new menu item connected to a user page (blog) i got this message : 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 i.id DESC LIMIT 0, 10' at line 1 SQL=SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM fmzl8_k2_items as i RIGHT JOIN fmzl8_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2015-07-19 21:50:48' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2015-07-19 21:50:48' ) AND i.created_by=461 AND i.created_by_alias='' AND c.id IN() ORDER BY i.id DESC LIMIT 0, 10

What i shall do?

My site is running on Joomla! 3.4.3 and k2 v2.6.9

Thanks for your time!
  • iatriko
  • iatriko's Avatar
14 Jul 2015 15:52
1064 error in k2 user page was created by iatriko

1064 error in k2 user page

Category: English K2 Community

This error came up when i try to open a new k2 user page after upgrade to 3.4.3.
The old k2 user page and everything else seems ok.


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 i.id DESC LIMIT 0, 5' at line 1 SQL=SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM j25_k2_items as i RIGHT JOIN j25_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2015-07-14 12:29:23' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2015-07-14 12:29:23' ) AND i.created_by=0 AND i.created_by_alias='' AND c.id IN() ORDER BY i.id DESC LIMIT 0, 5
  • Andreas Heckmann
  • Andreas Heckmann's Avatar
08 May 2015 17:10
Bug? in K2 search Plugin was created by Andreas Heckmann

Bug? in K2 search Plugin

Category: English K2 Community

I tried to activate the "search tags" option. When i did a search on my frontpage a weird sql error appears.

I changed in /plugins/search/k2/k2.php
line 91
to
$quoted = $db->Quote('%'.$escaped.'%', false);


and from line 104 to $querry
if ($phrase == 'exact') { $text = JString::trim($text, '"'); $escaped = K2_JVERSION == '15' ? $db->getEscaped($text, true) : $db->escape($text, true); $quoted = $db->Quote($escaped); $where = " ( LOWER(i.title) = ".$quoted." OR LOWER(i.introtext) = ".$quoted." OR LOWER(i.`fulltext`) = ".$quoted." OR LOWER(i.extra_fields_search) = ".$quoted." OR LOWER(i.image_caption) = ".$quoted." OR LOWER(i.image_credits) = ".$quoted." OR LOWER(i.video_caption) = ".$quoted." OR LOWER(i.video_credits) = ".$quoted." OR LOWER(i.metadesc) = ".$quoted." OR LOWER(i.metakey) = ".$quoted; } else { JArrayHelper::toInteger($itemIDs); $escaped = K2_JVERSION == '15' ? $db->getEscaped($text, true) : $db->escape($text, true); $quoted = $db->Quote('%'.$escaped.'%', false); $where = " ( LOWER(i.title) LIKE ".$quoted." OR LOWER(i.introtext) LIKE ".$quoted." OR LOWER(i.`fulltext`) LIKE ".$quoted." OR LOWER(i.extra_fields_search) LIKE ".$quoted." OR LOWER(i.image_caption) LIKE ".$quoted." OR LOWER(i.image_credits) LIKE ".$quoted." OR LOWER(i.video_caption) LIKE ".$quoted." OR LOWER(i.video_credits) LIKE ".$quoted." OR LOWER(i.metadesc) LIKE ".$quoted." OR LOWER(i.metakey) LIKE ".$quoted; } if ($pluginParams->get('search_tags') && count($itemIDs)) { JArrayHelper::toInteger($itemIDs); $where .= " OR i.id IN(".implode(',', $itemIDs).")"; } $where .= " )";

Mainly the %where lines are altered

Now it works for me!
  • Miguel
  • Miguel's Avatar
25 Apr 2015 17:57
Update K2 2.5.4 to 2.6.9 was created by Miguel

Update K2 2.5.4 to 2.6.9

Category: English K2 Community

Hi:
I'm moving a Joomla 1.5 website to a Joomla 3.3.6 website. I've moved successfully plenty of components of the website and now i'm moving the content of K2 however i copied all database tables from old joomla database to new joomla database and renamed the prefix.
Later i installed K2 but when i try to login in the front end i see an error:

1054
Error: 1054
Unknown column 'ip' in 'field list' SQL=INSERT INTO `ukeb2_k2_users` (`userID`,`userName`,`group`,`ip`,`hostname`) VALUES ('734','Super User','1','2.139.47.11','11.Red-2-139-47.dynamicIP.rima-tde.net')

I used this procedure because is the one described here: getk2.org/documentation/tutorials/76-upgrading-to-the-latest-k2-version-in-the-2x-series
But something obviously went wrong because the k2_users doesn't have any ip column.

I followed the wrong guide? Do i need to do anything else more?

Thanks.
Best regards.
  • metalbrain
  • metalbrain's Avatar
23 Apr 2015 23:04
Error 1136 While creating User Group in K2 was created by metalbrain

Error 1136 While creating User Group in K2

Category: English K2 Community

Hello,

To enable frontend item entries, I've tried to create a user group in K2.

But when I wanted to move my registered users to new group of K2, I got this error.
Column count doesn't match value count at row 1 SQL=INSERT INTO ve63d_k2_users VALUES ('', 66, 'dark_wall', '', '', '', '', 1, '')

How can I go forward?
  • Thyme
  • Thyme's Avatar
12 Apr 2015 21:28
With K2 system plugin enabled, user registration crashes was created by Thyme

With K2 system plugin enabled, user registration crashes

Category: English K2 Community

From the frontend when a create account is submitted, the page turns into a code page with message of:

Fatal error: Uncaught exception 'RuntimeException' with message 'Unknown column 'header' in 'field list' SQL=SELECT `new_url`,`header`,`published` FROM `alrvw_redirect_links` WHERE `old_url` = 'thymewisper.com/index.php/component/users/' LIMIT 0, 1' in /home4/thymewis/public_html/libraries/joomla/database/driver/mysqli.php:610 Stack trace: #0 /home4/thymewis/public_html/libraries/joomla/database/driver.php(1239): JDatabaseDriverMysqli->execute() #1 /home4/thymewis/public_html/plugins/system/redirect/redirect.php(86): JDatabaseDriver->loadObject() #2 [internal function]: PlgSystemRedirect::handleError(Object(Exception)) #3 {main} thrown in /home4/thymewis/public_html/libraries/joomla/database/driver/mysqli.php on line 610

If I disable the system redirect plugin, the submission turns into the error 404 page.

If I enable system direct plugin and disable system k2 plugin, the submission is successful.

I prefer the latter not only for ability to have people register to my site, but it is also the registration form from joomla and has the secure image captcha that I want to use because of my biggest audience (older group). However, K2 does not function without system K2 plugin and thus my items and categories and images that I for the past month have worked on from my import of several years worth of Joomla articles for is worthless.

Is there a way to use K2 for content, but not have it involved with users? I do a blog (which is main reason I wanted K2 with its comments, gallery, etc. ) but I do not plan on having other bloggers writing on my website.

In other words, how do I have user function not be used in K2 and just let my joomla site manage users, log in and registration?

Thank you in advance.
Displaying 181 - 200 out of 793 results.
  1. Forum
  3. Search

Powered by Kunena Forum