COMMUNITY FORUM

Keyword
  1. Forum
  3. Search

Advanced Search

Search Results (Searched for: Re Error SQL)

  • Lefteris
  • Lefteris's Avatar
02 Feb 2015 15:57
Replied by Lefteris on topic can't accesss items area - sql error 1191

can't accesss items area - sql error 1191

Category: English K2 Community

Hi,

The latest K2 does not include this kind of query. So you are either not using the latest version or a third-party plugin is making this query.
  • Mark Landry
  • Mark Landry's Avatar
31 Jan 2015 14:25 - 31 Jan 2015 16:01
Replied by Mark Landry on topic can't accesss items area - sql error 1191

can't accesss items area - sql error 1191

Category: English K2 Community

Now anything I try to access in the admin area gives me a 404 - this has happened multiple times over the past six months and i can't get any help on this forum.

I made a database backup before this happened, restored the db but it's not working.

I need you guys to please look at my files, me db, something to help. deadline is today and admin area is doa.

Thank you for your help

Edit - must have been a caching thing? waited about an hour, then re uploaded the good db and things are working again... any idea what's causing this? Also, sorry for my tone above, freaking out a bit over here...
  • Mark Landry
  • Mark Landry's Avatar
30 Jan 2015 20:05 - 30 Jan 2015 20:10
can't accesss items area - sql error 1191 was created by Mark Landry

can't accesss items area - sql error 1191

Category: English K2 Community

Hi,
Using the latest k2 and Joomla 3.0
I was in administrator > components > k2 > items and typed something in the search field.

I now get this error when attempting to access the items area:

1191 Can't find FULLTEXT index matching the column list SQL=SELECT COUNT(*) FROM cvyse_k2_items AS i WHERE trash=0 AND MATCH( title ) AGAINST ('+events*' IN BOOLEAN MODE)


edit - can't use the search filter at all without getting this error

Thanx for your help
  • duncan12
  • duncan12's Avatar
29 Jan 2015 22:50 - 29 Jan 2015 23:56
[SOLVED] uninstall of K2 results in error 1146 - FIXED was created by duncan12

[SOLVED] uninstall of K2 results in error 1146 - FIXED

Category: English K2 Community

I just migrated my entire k2 site from Joomla 1.5 to Joomla 3.x. Then I used foobla to migrate all the content to Joomla content manager. Everything worked great. Then I uninstalled K2 (sorry, but the clients don't want it)...

Now I am screwed. When I go to the joomla content manager I get an error:

1146 Table 'db78299_seij3.u8jqh_k2_items' doesn't exist SQL=SELECT COUNT(*) AS count FROM u8jqh_k2_items

I can't interact with any of my content as the remainder of the page is blank. Here's what I've tried:
  • I confirmed that all K2 modules/plugins have been uninstalled.
  • I confirmed that no modules exist that are trying to load K2 items or categories
  • In extension manager I confirmed that there are no errors
  • In php my admin I ran a database repair
  • I cleared my cache

Thoughts? Ideas?

For some reason the Joomla content manager is trying to load something from a non-existent k2 table.
  • Al
  • Al's Avatar
29 Jan 2015 13:46 - 29 Jan 2015 13:47
Can't upload K2 v2.6.9 on Joomla 3.3.6. was created by Al

Can't upload K2 v2.6.9 on Joomla 3.3.6.

Category: English K2 Community

Hello,
I am kind of new Joomla! user and I am building my first site. I tried to upload a K2 extension (version 2.6.9) through Extension Manager, and after I press install, the system responde me "An error has occurred."

1146 Table 'o.zgrxp_k2_user_groups' doesn't exist SQL=SELECT COUNT(*) FROM zgrxp_k2_user_groups

What should I do to upload the extension?

Thanks for your help
  • John Vincent
  • John Vincent's Avatar
27 Jan 2015 17:59
User Error Joomla! 500 - An error has occurred. Unknown co was created by John Vincent

User Error Joomla! 500 - An error has occurred. Unknown co

Category: English K2 Community

Hi,

I am not sure if this is related to K2 but I have imported all my users from Joomla. In the Joomla User control panel when I try to sort or save the users i get the error below. But I can access the users if I go to K2 > users

Any ideas on whats going on or link to a solution would be great

Thanks

John

500 - An error has occurred. Unknown column 'a.usertype' in 'group statement' SQL=SELECT a.* FROM `j25_users` AS a LEFT JOIN j25_user_usergroup_map AS map2 ON map2.user_id = a.id WHERE map2.group_id = 8 AND (a.name LIKE '%%' OR a.username LIKE '%%' OR a.email LIKE '%%') GROUP BY a.id,a.name,a.username,a.password,a.usertype,a.block,a.sendEmail,a.registerDate,a.lastvisitDate,a.activation,a.params,a.email ORDER BY a.name asc Unknown column 'a.usertype' in 'group statement' SQL=SELECT a.* FROM `j25_users` AS a LEFT JOIN j25_user_usergroup_map AS map2 ON map2.user_id = a.id WHERE map2.group_id = 8 AND (a.name LIKE '%%' OR a.username LIKE '%%' OR a.email LIKE '%%') GROUP BY a.id,a.name,a.username,a.password,a.usertype,a.block,a.sendEmail,a.registerDate,a.lastvisitDate,a.activation,a.params,a.email ORDER BY a.name asc LIMIT 0, 20 Unknown column 'a.usertype' in 'group statement' SQL=SELECT a.* FROM `j25_users` AS a LEFT JOIN j25_user_usergroup_map AS map2 ON map2.user_id = a.id WHERE map2.group_id = 8 AND (a.name LIKE '%%' OR a.username LIKE '%%' OR a.email LIKE '%%') GROUP BY a.id,a.name,a.username,a.password,a.usertype,a.block,a.sendEmail,a.registerDate,a.lastvisitDate,a.activation,a.params,a.email ORDER BY a.name asc Return to Control Panel
  • Sabrina Münz
  • Sabrina Münz's Avatar
21 Jan 2015 21:41
Replied by Sabrina Münz on topic Installing Problems

Installing Problems

Category: English K2 Community

Hello Krikor,

thank you. I have to tell you what happened. The Homepage I've create were first on a test server. With akeeba backup and akeeba kickstart I've load the page on the right server. There were first some problems but than it works.

Now I've tried your proposal. It doesn't install the Admin Tools. I think there is something wrong … perhaps it is the provider? I've installed the Admin Tools on my test server. It works and the permissions are 755 and 644. I think they are correct. I've installed the K2 there but now it is new error

1146 Table 'db146234x2188236.dq6m9_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `dq6m9_k2_categories`
  • goran mihajlovic
  • goran mihajlovic's Avatar
19 Jan 2015 22:13
sql error 1064 just sometimes !! was created by goran mihajlovic

sql error 1064 just sometimes !!

Category: English K2 Community

Hi...

Please help me out of this problem....

When i select an item from the menu it show

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 ') GROUP BY comments.itemID' at line 11 SQL=SELECT content.id AS id, COUNT(comments.itemID) AS count FROM guzto_k2_items AS content LEFT JOIN guzto_k2_comments AS comments ON comments.itemID = content.id WHERE comments.published AND ( ) GROUP BY comments.itemID ;

even if the item is a wrapper.

if you are on the startpage and select from the left module any item.. then you got the message.... but if you select the last menu item and any of the subitems the site works even the left module selections... which was not working in startpage....

I don't really know if you understand me but you have to visit the site and make the selections...

the k2 is 2.6.9 and joomla is 3.2.3

Best Regards

MICROweb
  • Jens Lorentsen
  • Jens Lorentsen's Avatar
17 Jan 2015 11:20
Replied by Jens Lorentsen on topic Web installer killing entire site

Web installer killing entire site

Category: English K2 Community

Or maybe it wasnt the web installer. I get this when attempting installation from manually downloaded file:

An error has occurred.
1146 Table 'jlorentsen_jensl.bir41_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `bir41_k2_categories`
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
16 Jan 2015 12:58
Replied by Krikor Boghossian on topic MySQL item genertaion?

MySQL item genertaion?

Category: English K2 Community

Wouldn't recommend it. One error and you might lose hours hours of your time.
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
15 Jan 2015 18:40
Replied by Krikor Boghossian on topic MySQL Error on use Joomla search module

MySQL Error on use Joomla search module

Category: English K2 Community

You 're welcome.
  • Lefteris
  • Lefteris's Avatar
13 Jan 2015 13:31
Replied by Lefteris on topic MySQL Error on use Joomla search module

MySQL Error on use Joomla search module

Category: English K2 Community

Try to replace the file plugins/search/k2/k2.php with this file: github.com/joomlaworks/k2/blob/master/plugins/search/k2.php . Let me know if that solves your issue.
  • Lefteris
  • Lefteris's Avatar
12 Jan 2015 13:58
Replied by Lefteris on topic MySQL Error on use Joomla search module

MySQL Error on use Joomla search module

Category: English K2 Community

@LTM Walter

What's your Joomla! version? Which K2 version are you using?
  • LTM Walter
  • LTM Walter's Avatar
12 Jan 2015 10:16
Replied by LTM Walter on topic MySQL Error on use Joomla search module

MySQL Error on use Joomla search module

Category: English K2 Community

Hi,

Disabling the tags in the K2 search plugin did solve the problem for now, so thank you for your input. However we obviously would like to keep searching in K2 tags because we do not add tags for no reason :)

So if anyone has a solution that let's us keep searching using K2 tags I'd gladly hear it.
  • rufina
  • rufina's Avatar
10 Jan 2015 10:52
error 1064 was created by rufina

error 1064

Category: English K2 Community

Hello.

Suddenly editing from the frontend stopped working. Though it had been working before.

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 TRASH = 0' AT LINE 1 SQL=SELECT MAX(ORDERING) FROM M8KYX_K2_ITEMS WHERE CATID = AND TRASH = 0

I have read similar messages on the forum and in most cases the error was caused by some other extensions. But I can't imaging what it could be in my case. I did not install anything in between it had been working and it stopped.
  • LTM Walter
  • LTM Walter's Avatar
09 Jan 2015 14:31
Replied by LTM Walter on topic MySQL Error on use Joomla search module

MySQL Error on use Joomla search module

Category: English K2 Community

Hi,

I have reinstalled K2 succesfully but the error still remains.
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
09 Jan 2015 13:43
Replied by Krikor Boghossian on topic MySQL Error on use Joomla search module

MySQL Error on use Joomla search module

Category: English K2 Community

Hello,

Try reinstalling K2 (do NOT unistall it first).
If that does not work let me know.
  • LTM Walter
  • LTM Walter's Avatar
09 Jan 2015 12:50
MySQL Error on use Joomla search module was created by LTM Walter

MySQL Error on use Joomla search module

Category: English K2 Community

Hi,

My website suddenly gives an SQL error when I try to search on it. The 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 published=1' at line 1 SQL=SELECT id FROM #__k2_tags WHERE LOWER(name) LIKE AND published=1

The website:
NVRO

I have no idea why this error is suddenly popping up and currently I have no idea how to fix it. I have googled a bunch but no one seems to have had this particular error

Hopefully someone here can help, many thanks in advance.
  • Adrien
  • Adrien's Avatar
03 Jan 2015 14:40
Error K2 item save : 1062 Duplicate entry was created by Adrien

Error K2 item save : 1062 Duplicate entry

Category: Communauté française K2

Bonjour,

Lorsque j'enregistre un article/item K2 j'ai l'erreur suivante 1062 :

"Une erreur s'est produite

1062 Duplicate entry '119-1' for key 'PRIMARY' SQL=INSERT INTO `kqhmd_finder_links_termsd` (`link_id`, `term_id`, `weight`) SELECT 119, `term_id`, ROUND(SUM(`context_weight`), 8) FROM `kqhmd_finder_tokens_aggregate` WHERE `map_suffix` = 'd' GROUP BY `term` ORDER BY `term` DESC "

Merci de m'aider à résoudre ce "bug" dans K2
  • Mr_Anonymous
  • Mr_Anonymous's Avatar
20 Dec 2014 16:02
Replied by Mr_Anonymous on topic 500 internal Server Error

500 internal Server Error

Category: English K2 Community

500 server error is the most annoying error to troubleshoot since it can be anything. It really means that 'something' caused an error on your web server and the server logs should tell you what it is. if you are not familiar with checking out the server logs, note down the time you saw the error on your site and ask your hosting provider to send you the extract of server logs for that time period. You need to take a look at Apache log, php log and mysql log. That will tell you what the reason was.
Displaying 221 - 240 out of 793 results.
  1. Forum
  3. Search

Powered by Kunena Forum