COMMUNITY FORUM

Keyword
  1. Forum
  3. Search

Advanced Search

Search Results (Searched for: Re Error SQL)

  • felipergueza
  • felipergueza's Avatar
03 Jan 2014 03:30 - 03 Jan 2014 06:29
Replied by felipergueza on topic [Resuelto] Como agregar 2 o mas Categorias en Articulo en k2

[Resuelto] Como agregar 2 o mas Categorias en Articulo en k2

Category: Comunidad hispana oficial de K2

Captura de pantalla front end al ir al componente instalado.

Error en el fron tend al querer publicar desde el front end.:
Fatal error: Call to undefined method RuntimeException::get() in C:\xampp\htdocs\joomla_32\templates\mitemplete\error.php on line 20

Nota: El mismo problema se genera en un sitio remoto.
En el sitio remoto cuando se preocede a crear un nuevo articulo desde k2 surge el siguiente error:
SQL=SELECT `catid` FROM xemh8_k2_additional_categories WHERE `itemID` = {intval()}

Anexo video del proceso que he realizado.
www.youtube.com/watch?v=-v8RyWqJ_oo
  • bertm
  • bertm's Avatar
01 Jan 2014 08:35 - 01 Jan 2014 08:40
Database error (corruption) when using mod_k2users was created by bertm

Database error (corruption) when using mod_k2users

Category: English K2 Community

mod_k2_users corrupts the database and generates this error. A 1 minute video screen grab is attached that shows when and how this happens. Please view it.

ERROR MESSAGE 1054 Unknown column 'juser.usertype' in 'order clause' SQL=SELECT juser.*, k2user.group, k2group.name as groupname FROM psg_users as juser LEFT JOIN psg_k2_users as k2user ON juser.id=k2user.userID LEFT JOIN psg_k2_user_groups as k2group ON k2user.group=k2group.id LEFT JOIN psg_user_usergroup_map as `map` ON juser.id=map.user_id WHERE juser.id>0 GROUP BY juser.id ORDER BY juser.usertype asc LIMIT 0, 100

This error is triggered when accessing the settings for "Retrieve Specific Users" on the back end of this module (K2 v2.6.7, J31, Php 5.3.x). When I sort the UserList by GROUP, this error is triggered and I can no longer access the user database via K2.

video would not upload, but here is an external link.
cloudserver2.com/k2-error.mp4
  • harnisa
  • harnisa's Avatar
31 Dec 2013 03:22 - 31 Dec 2013 03:24
Error while retrieving the Filters DataSet: was created by harnisa

Error while retrieving the Filters DataSet:

Category: English K2 Community

Hi,

I got this error & I don't know what should I do.

Error while retrieving the Filters DataSet:
Table 'prestijb_eve2s.rs8qb_k2_categories' doesn't exist SQL=SELECT a.id, a.name, a.parent
FROM rs8qb_k2_categories AS a WHERE a.id > 0 AND a.published IN (0,1)
ORDER BY a.parent, a.ordering

Can you please help me? What should I do?
  • Gopal
  • Gopal's Avatar
30 Dec 2013 11:42 - 30 Dec 2013 11:43
Hi im getting 500 error while saving k2 item... was created by Gopal

Hi im getting 500 error while saving k2 item...

Category: English K2 Community

:( :(

500 - An error has occurred.
Table 'istudiotech_news.gnk6z_finder_types' doesn't exist SQL=SELECT `id` FROM `gnk6z_finder_types` WHERE `title` = 'K2 Item'


i dont how to fix this error...ll u Please could you advise.
  • Nikos
  • Nikos's Avatar
26 Dec 2013 05:43 - 26 Dec 2013 05:44
Replied by Nikos on topic Cannot save or edit from frontend NOR backend

Cannot save or edit from frontend NOR backend

Category: English K2 Community

Hello Jennifer

kunle wrote: K2 v2.6.2
Php 5.3.10
MySQL 5.5.20
Joomla 2.5.8

I'm currently building a site offline using wampserver so after installing K2 I noticed neither 'Save & Close' nor 'Save & New' buttons worked in back-end.

Then in the JS error console (using firefox browser) I noticed these errors:

Get ajax.googleapis.com/ajax/libs/jquery/1.8/jquery.min.js

X ReferenceError: jQuery is not defined

Get ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js

X TypeError: $K2 is not a function

Since the system is not connected to internet I guessed the 'http' header for 'googleapis' might be the cause so here's what I did that fixed it:

Navagated to K2 Parameter i.e.
Parameters > Layouts & Views > CSS & JavaScript Settings > Backend jQuery & jQuery UI handling

By default it was set to 'Load a remote copy of jQuery & UI' so I switched this to 'Load a local copy of jQuery & UI' then saved the settings. Now the 'Save & Close' and 'Save & New' buttons works fine.

Went back to JS error console (using firefox browser) refreshed the screen and
'X ReferenceError: jQuery is not defined' and
'X TypeError: $K2 is not a function' errors are not shown anymore.

As soon as my site is developed & put on a hosting server I shall switch back to 'Load a remoted copy of jQuery UI to see If the error will return.


Have you tried this solution?
  • Nikos
  • Nikos's Avatar
26 Dec 2013 05:22
Replied by Nikos on topic [SOLVED] Re: K2 front-end save and close

[SOLVED] Re: K2 front-end save and close

Category: English K2 Community

kunle wrote: K2 v2.6.2
Php 5.3.10
MySQL 5.5.20
Joomla 2.5.8

I'm currently building a site offline using wampserver so after installing K2 I noticed neither 'Save & Close' nor 'Save & New' buttons worked in back-end.

Then in the JS error console (using firefox browser) I noticed these errors:

Get ajax.googleapis.com/ajax/libs/jquery/1.8/jquery.min.js

X ReferenceError: jQuery is not defined

Get ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js

X TypeError: $K2 is not a function

Since the system is not connected to internet I guessed the 'http' header for 'googleapis' might be the cause so here's what I did that fixed it:

Navagated to K2 Parameter i.e.
Parameters > Layouts & Views > CSS & JavaScript Settings > Backend jQuery & jQuery UI handling

By default it was set to 'Load a remote copy of jQuery & UI' so I switched this to 'Load a local copy of jQuery & UI' then saved the settings. Now the 'Save & Close' and 'Save & New' buttons works fine.

Went back to JS error console (using firefox browser) refreshed the screen and
'X ReferenceError: jQuery is not defined' and
'X TypeError: $K2 is not a function' errors are not shown anymore.

As soon as my site is developed & put on a hosting server I shall switch back to 'Load a remoted copy of jQuery UI to see If the error will return.


Thank you very much man that did the trick for me. So we have to use still the 1.8.x version of jquery in order to save and create items in frontend and of course to check permissions!
Merry Christmas everybody!
  • Adam
  • Adam's Avatar
17 Dec 2013 11:47
Replied by Adam on topic [SOLVED] "An error has occurred." when saving anything

[SOLVED] "An error has occurred." when saving anything

Category: English K2 Community

Hi, I was experiencing similar problems to ovsovso.

Since a Joomla update yesterday I was getting similar error messages when trying to save K2 items.

I found that normal Joomla articles were fine.

I went to run an akeeba backup before doing anything but that wouldn't work as it also generated error messages when I tried to run it. I have a backup from fairly recently anyway so it's not tooooo much of a problem.

Following reading this thread, I also tried to reinstall K2. Unfortunately, the problem now seems to have got worse.

The section of my site which delivers K2 content is now down and now only displays a page with the following error:

SQL=SELECT i.*, CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM sltzy_k2_items as i RIGHT JOIN sltzy_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 <= '2013-12-17 09:30:55' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-12-17 09:30:55' ) AND c.id IN (12) ORDER BY i.publish_up DESC LIMIT 0, 10

When I go to the admin panel and select components -> K2, I now just get the error message:

"An error has occurred

0 SQL=SELECT COUNT(*) FROM sltzy_k2_items AS i WHERE trash=0 AND catid IN (12)"

Any help would be greatly appreciated. I was on the cusp of launching the site tonight and now everything has gone completely wrong!

Many thanks
  • nifi
  • nifi's Avatar
16 Dec 2013 17:10
[SOLVED] "An error has occurred." when saving anything was created by nifi

[SOLVED] "An error has occurred." when saving anything

Category: English K2 Community

When I save an article or update a category I get a Error Message page which says "An error has occurred. 0 SQL=UPDATE `jos_k2_items` SET `title`=' .... and then the whole articel as an SQL Statement. There's no real Error Message but from the looks I guess it has something to do with my database. I can save articles outside of K2 with the joomla editor. I recently migrated joomla from 1.5 to 3, so there should be the problem somewhere. Does anybody have an idea what could cause this probem? Thank you!
  • Wrina
  • Wrina's Avatar
13 Dec 2013 22:28 - 13 Dec 2013 22:34
Not able to load K2 was created by Wrina

Not able to load K2

Category: English K2 Community

I have tried to load K2 several times, for Joomla 3 -- also tried when 1.5 was the thing... neither times was I able to upload... however, this time i am determined to be a K2er.

I receive error message: SQL=SHOW FULL COLUMNS FROM "cntv_k2_category'

Only one problem, when i log in to my database there is no k2_ .


Any help would be appreciated:
Joomla Version: 3 (up-to-date)
hosted by Godaddy
Php ver: 5.3
Mysql Server: 5.0.96

NOTE:: I have already tried the following, from the genral loading area (should I ftp it??) the same error as noted above occurs::

......Forum Posting::::::Please upgrade your Joomla! version to the latest and install K2 SVN version from here getk2.org/assets/get/

Thank you for your help
  • webloesung
  • webloesung's Avatar
13 Dec 2013 21:36
Replied by webloesung on topic [SOLVED] Order tags in Add Article Form

[SOLVED] Order tags in Add Article Form

Category: English K2 Community

going to be interresting :)

did the following:
 
 
     
  •  Yiota 
    •  
  • Yiota's Avatar
    •  
 
 
   06 Dec 2013 12:54  
 
 Replied by Yiota on topic Error: 500 SQL=SHOW FULL COLUMNS FROM 
 
 Error: 500 SQL=SHOW FULL COLUMNS FROM 
 
 Category: English K2 Community 
 
 @OtdohniPerm Perm
 
 English please.
 
 @mimi72
 
 Please upgrade your Joomla! version to the latest and install K2 SVN version from here getk2.org/assets/get/
  • OtdohniPerm Perm
  • OtdohniPerm Perm's Avatar
05 Dec 2013 23:15
Replied by OtdohniPerm Perm on topic Error: 500 SQL=SHOW FULL COLUMNS FROM

Error: 500 SQL=SHOW FULL COLUMNS FROM

Category: English K2 Community

Вся проблема в не удаленных папках и файлах после деинстализации К2. Нужно зачистить на сервере все папки "К2" в ручную.Тогда установиться.
  • Yiota
  • Yiota's Avatar
04 Dec 2013 12:23
Replied by Yiota on topic yet another 1064 You have an error in your SQL

yet another 1064 You have an error in your SQL

Category: English K2 Community

Do you use a third party K2 plugin?
  • Joe Allen
  • Joe Allen's Avatar
03 Dec 2013 17:04
[SOLVED] Re: yet another 1064 You have an error in your SQL was created by Joe Allen

[SOLVED] Re: yet another 1064 You have an error in your SQL

Category: English K2 Community

Fixed it!!

Just because I had not added the article image, makes sense!! doh ... :)
  • Joe Allen
  • Joe Allen's Avatar
03 Dec 2013 16:53
yet another 1064 You have an error in your SQL was created by Joe Allen

yet another 1064 You have an error in your SQL

Category: English K2 Community

Hi,

If anyone can shed some light on why this is happening every time I try and add a new article. Using J3.2.

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 1 SQL=UPDATE `c9vql_finder_taxonomy_map` SET `link_id`='6',`node_id`='3' WHERE

Thanks,

Joe
  • Wire Creative
  • Wire Creative's Avatar
03 Dec 2013 08:51
Error: 1136 Column Count Doesn't Match Value Count was created by Wire Creative

Error: 1136 Column Count Doesn't Match Value Count

Category: English K2 Community

Hi, I'm trying to figure out how to fix a site that broke shortly after updating from Joomla 3.1.5 to 3.2.

After running that update, the site seemed fine until I logged out and tried to login again later. Now when I log in to the admin area, I get this error:

An error has occurred.
1136 Column count doesn't match value count at row 1 SQL=INSERT INTO hmwmh_user_usergroup_map (user_id,group_id) VALUES (549),(7)


There appears to be a syntax error which is writing "(549),(7)" instead of "(549,7)".

I've searched the site files and I think I may have found the offending bit of code in the file "administrator/components/com_k2/models/users.php" but I'm not smart enough to parse it correctly.

Here's line 420:
$query = "INSERT INTO #__user_usergroup_map VALUES (".$id.", ".implode("), (".$id.", ", $group).")";

Is the syntax on that last part correct, or could it be causing this error? It loses me at "implode" but it looks like the nesting may be off or there may be one too many commas.

I also updated K2 during this same work session, so it's possible it could be K2-related. Apologies in advance if I'm barking up the wrong tree here.

Thanks,
Greg
  • web brand
  • web brand's Avatar
02 Dec 2013 11:58
problema tabella comments was created by web brand

problema tabella comments

Category: Comunità italiana K2

Ciao ho aggiornato joomla all'ultima versione ma dopo qualche giorno il componente k2 ha smesso di funzionare perchè se vado sul sito mi viene restituito l'errore 1146 - Table 'Sql607408_3.i94wk_k2_comments' doesn't exist SQL=SELECT COUNT(*) FROM i94wk_k2_comments WHERE itemID=65 AND published=1


www.webagencytorino.info/i-nostri-servizi

cose è successo?
Grazie
  • Daniel Warner
  • Daniel Warner's Avatar
02 Dec 2013 10:27
_k2_categories' doesn't exist SQL=SHOW FULL COLUMN was created by Daniel Warner

_k2_categories' doesn't exist SQL=SHOW FULL COLUMN

Category: English K2 Community

Hi All,

I've used K2 alot. It's great but I'm having this issue:

While I'm installing it I get this error - 1146 Table 'avaelis_design.wig7m_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `wig7m_k2_categories`

I'm ensured the permissions are all correct. I've never had the problem before. Everything is writable

Setting Value

PHP Built On Linux Centos-VPS.interweaving.com 2.6.18-371.1.2.el5 #1 SMP Tue Oct 22 12:51:53 EDT 2013 x86_64
Database Version 5.5.32-cll
Database Collation utf8_general_ci
PHP Version 5.3.18
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.2.0 Stable [ Ember ] 6-November-2013 14:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0

I've gone back to an earlier version of K2 but I get the same error. It leads me to believe this may be a K2 issue with Joomla 3.2

Ideas?
  • Dale R Gingerich
  • Dale R Gingerich's Avatar
01 Dec 2013 22:07
JPath::clean: $path is not a string. was created by Dale R Gingerich

JPath::clean: $path is not a string.

Category: English K2 Community

Will try another attempt at requesting some help,

Web Server Apache mod_fcgid/2.3.10-dev
PHP version 5.4.21
MySQL version 5.5.32-cll-lve
GD image library bundled (2.1.0 compatible)
Multibyte string support Enabled
Upload limit 10M
Memory limit 256M
Open remote files (allow url fopen) Yes
Joomla! 3.2.0 Stable [ Ember ] 6-November-2013 14:00 GMT

When I attempt to "Import Joomla! Content"

I receive the following error:

An error has occurred.
0 JPath::clean: $path is not a string.

And then asking me to return to the control panel

I have also tried the latest dev package from today and same error (numerous times)

Have also adjusted/edited/changed/put back tmp directories, permissions, etc.

I am able to install extensions, etc without error/problems

Any suggestions greatly appreciated,

Thanks in advance,

Dale
  • Wayne Farnworth
  • Wayne Farnworth's Avatar
25 Nov 2013 20:51
[SOLVED] K2 Media Manager - Unable to connect to back end was created by Wayne Farnworth

[SOLVED] K2 Media Manager - Unable to connect to back end

Category: English K2 Community

Hello

I can't browse the server for images to add to my articles/posts. I get the error unable to connect to back end.

Joomla media manager works OK
I tried disabling error reporting

I have disabled all unnecessary plugins

Problem still exists.

Very grateful of any help with this as it is quite problematic not to be able to use the media manager.

Some server info:

PHP Environment :: Discovery
PHP VERSION:
5.3.27
PHP API:
APACHE
DISPLAY ERRORS:
1
ERROR REPORT LEVEL:
22519
MYSQLI SUPPORT:
YES
MAGIC QUOTES:
0
SAFE MODE:

MEMORY LIMIT:
128M
UPLOADS ENABLED:
1
MAX. UPLOAD SIZE:
30M
MAX. POST SIZE:
30M
MAX. INPUT TIME:
60 SECONDS
MAX. EXECUTION TIME:
90 SECONDS
REGISTER GLOBALS:
0

OPEN BASE PATH:
/svr/apachessl/htdocs:/tmp:/usr/local/lib/php:/usr/share:/etc/xml:/usr/bin-safe:/home
SESSION PATH:
/tmp
SESSION PATH WRITABLE:
Yes
INI FILE PATH:
/usr/local/lib/php.ini
LAST KNOWN PHP ERROR:
None
Displaying 361 - 380 out of 793 results.
  1. Forum
  3. Search