COMMUNITY FORUM

Keyword
  1. Forum
  3. Search

Advanced Search

Search Results (Searched for: Re Error SQL)

  • Roberto Robuffo
  • Roberto Robuffo's Avatar
22 May 2014 22:05
Disinstallare k2 was created by Roberto Robuffo

Disinstallare k2

Category: Comunità italiana K2

Buongiorno,
ho acquistato un template con all'interno k2 che vorrei disinstallare...

Sono andato su gestione estensioni - gestisci e ho cercato con il filtro k2

dopo aver disinstallato tutto nel front end ho questo errore
TABLE 'C2ESSEPI.NRK5E_K2_CATEGORIES' DOESN'T EXIST SQL=SELECT DISTINCT C.ID AS ID, C.NAME AS NAME, C.ALIAS AS ALIAS FROM NRK5E_K2_CATEGORIES AS C LEFT JOIN NRK5E_K2_ITEMS AS CONTENT ON C.ID = CONTENT.CATID WHERE ( C.ID = 1 ) AND C.PUBLISHED = 1 AND C.ACCESS <= 3;

Che devo fare??

Grazie a chi mi vuol dare una mano :D
  • Gary
  • Gary's Avatar
21 May 2014 14:57
install failure on joomla 3.3 was created by Gary

install failure on joomla 3.3

Category: English K2 Community

here is the problem, after many complete uninstall and reinstalls of joomla the result is always that a table does not install.



An error has occurred.

1146 Table 'server27_jmln1.jom_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `jom_k2_categories`



does anyone have an answer please? thanks.
  • tatlink
  • tatlink's Avatar
15 May 2014 07:19
can't to add new k2 article. Arror: 1064 was created by tatlink

can't to add new k2 article. Arror: 1064

Category: English K2 Community

can't add new k2 article. Arror:
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=SELECT `catid` FROM jos_k2_additional_categories WHERE `itemID` = {intval()}


Joomla 3.3.0
Apache/1.3.42 (Unix) PHP/5.3.13
PHP 5.3.13
MySQL 5.1.73-log
  • Alex Walker
  • Alex Walker's Avatar
07 May 2014 19:16
Replied by Alex Walker on topic [SOLVED] PHP error

[SOLVED] PHP error

Category: AllVideos

Hi I am getting the same message as well
Warning: preg_replace() [function.preg-replace]: Unknown modifier '0' in /home/XXXXX/public_html/XXXXXXX/plugins/content/jw_allvideos/jw_allvideos.php on line 390

Allvideos 4.5.0
Joomla 3.3.0
PHP 5.3.28
Mysql 5.5.36-34.2
  • executor
  • executor's Avatar
30 Apr 2014 01:13
error when adding item on front end was created by executor

error when adding item on front end

Category: English K2 Community

When I click the link to add item on the k2 user module I get this error:
SQL=SELECT `catid` FROM jos_k2_additional_categories WHERE `itemID` = {intval()}
I think it is related to the plugin: Additional Categories for K2 because when i disable it add item works.
This completely breaks my site because it based on user generated content.
Does any one know how to fix this or know of any free alternative plugins.
My site is bypassgames.com/
When I click on my page i get a 404 error but I think this is related to my sef settings.
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
29 Apr 2014 21:27 - 29 Apr 2014 21:31
Replied by Krikor Boghossian on topic Akeeba help

Akeeba help

Category: Commercial Joomla Templates

You should probably delete this after you 've read this post.

public $host = 'db525967187.db.1and1.com'; Is this correct, 99% it 's localhost, although I admit I 've never worked with 1and1.
Other than that I can not spot any issues.

PS. Use the contact form - nuevvo.com/contact - to send us any credentials.
PS2. The db error is caused by K2Store you try enabling/disabling the extension to see if the rest of the site works.
Futhermore you can look up the error in their support to see if there is a solution posted. k2store_currency' doesn't exist SQL=SELECT
  • Christopher Buckingham
  • Christopher Buckingham's Avatar
29 Apr 2014 20:58
Replied by Christopher Buckingham on topic Akeeba help

Akeeba help

Category: Commercial Joomla Templates

I haven't extracted the .jpa file yet.

I went to extension manager and update.. i updated all extensions. I am downloading Joomla 3.2.3 update to update the version.

I don't know which files were deleted. Would it be helpful to send you a screenshot of my ftp file structure or give you a login?

regarding earlier question: configuration php.. this is how it is configured:
<?php
class JConfig {
public $MetaAuthor = '1';
public $MetaDesc = '';
public $MetaKeys = '';
public $MetaRights = '';
public $MetaTitle = '1';
public $MetaVersion = '0';
public $access = '1';
public $cache_handler = 'file';
public $cachetime = '15';
public $caching = '0';
public $captcha = '0';
public $cookie_domain = '';
public $cookie_path = '';
public $db = 'db525967187';
public $dbprefix = 'xs8ea_';
public $dbtype = 'mysqli';
public $debug = '0';
public $debug_lang = '0';
public $display_offline_message = '1';
public $editor = 'tinymce';
public $error_reporting = 'development';
public $feed_email = 'author';
public $feed_limit = '10';
public $force_ssl = '0';
public $fromname = 'Kendra Larson';
public $ftp_enable = '0';
public $ftp_host = '';
public $ftp_pass = '';
public $ftp_port = '21';
public $ftp_root = '';
public $ftp_user = '';
public $gzip = '0';
public $helpurl = 'help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}';
public $host = 'db525967187.db.1and1.com';
public $lifetime = '15';
public $list_limit = '20';
public $live_site = '';
public $log_path = '/homepages/17/d238653656/htdocs/stcreative/log';
public $mailer = 'mail';
public $mailfrom = 'This email address is being protected from spambots. You need JavaScript enabled to view it.';
public $memcache_compress = '1';
public $memcache_persist = '1';
public $memcache_server_host = 'localhost';
public $memcache_server_port = '11211';
public $offline = '0';
public $offline_image = '';
public $offline_message = 'This site is down for maintenance.<br /> Please check back again soon.';
public $offset = 'UTC';
public $offset_user = 'UTC';
public $password = '**deleted this**';
public $robots = '';
public $secret = '';
public $sef = '1';
public $sef_rewrite = '0';
public $sef_suffix = '0';
public $sendmail = '/usr/sbin/sendmail';
public $session_handler = 'database';
public $sitename = 'Stumptown Creative';
public $sitename_pagetitles = '1';
public $smtpauth = '0';
public $smtphost = 'localhost';
public $smtppass = '';
public $smtpport = '25';
public $smtpsecure = 'none';
public $smtpuser = '';
public $tmp_path = '/homepages/17/d238653656/htdocs/stcreative/tmp';
public $unicodeslugs = '0';
public $user = 'dbo525967187';
}
  • Krikor Boghossian
  • Krikor Boghossian's Avatar
29 Apr 2014 19:21 - 29 Apr 2014 19:25
Replied by Krikor Boghossian on topic Akeeba help

Akeeba help

Category: Commercial Joomla Templates

You need to do two things at the moment,

1) Turn on error reporting (Global Configuration -> Server Tab) to see why your site is failing.
2) Head on to akeeba.com to see how you can extract and use jpa files.

Update: I see the errorMsg: 'Table 'db525967187.xs8ea_k2store_currency' doesn't exist SQL=SELECT *
make sure you have selected the proper table prefix xs8ea in your configuration.php file.
  • nurv
  • nurv's Avatar
26 Apr 2014 17:28 - 26 Apr 2014 17:30
Replied by nurv on topic [SOLVED] Date and time problem

[SOLVED] Date and time problem

Category: English K2 Community

installed the file and now when trying to add a new item i get 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 ')}' at line 1 SQL=SELECT `catid` FROM fdaux_k2_additional_categories WHERE `itemID` = {intval()}



EDIT: Nevermind, it was the additional categories plugin. disabled and it works...
  • Dimitris X Kalogirou
  • Dimitris X Kalogirou's Avatar
22 Apr 2014 13:24 - 22 Apr 2014 13:38
Replied by Dimitris X Kalogirou on topic [SOLVED] Error 0 on K2 categories

[SOLVED] Error 0 on K2 categories

Category: English K2 Community

Hey there!

Just tried that.. I disabled the comments for the whole website but still nothing :S

This is so weird!! Also if i try to access comments from the k2 panel I also get a similar error:

SQL=SELECT COUNT(*) FROM sl914_k2_comments AS c LEFT JOIN sl914_k2_items AS i ON c.itemID=i.id WHERE c.id>0 AND c.published=1

EDIT: I just found out that sl914_k2_comments is missing from my database!!! I will try it reimport it from an old one and see what happens... brb


EDIT 2: Yup!! THAT DIT IT!! although its pretty weird that a whole database table just disappeared... Anyway hope that helps everyone else :)
  • Dimitris X Kalogirou
  • Dimitris X Kalogirou's Avatar
22 Apr 2014 12:57
Replied by Dimitris X Kalogirou on topic [SOLVED] Error 0 on K2 categories

[SOLVED] Error 0 on K2 categories

Category: English K2 Community

Same problem here!! You can see it here www.4qk-creations.com/en in every category i get error 0 and also I cannot login to my control panel because i get this error:

SQL=SELECT i.*, v.name AS author, COUNT(comments.id) AS numOfComments FROM sl914_k2_items as i LEFT JOIN sl914_k2_categories AS c ON c.id = i.catid LEFT JOIN sl914_users AS v ON v.id = i.created_by RIGHT JOIN sl914_k2_comments comments ON comments.itemID = i.id WHERE i.trash = 0 AND c.trash = 0 GROUP BY i.id ORDER BY numOfComments DESC LIMIT 0, 10

PLEASE HELP!!
  • Ohara Viktor
  • Ohara Viktor's Avatar
17 Apr 2014 13:51
Replied by Ohara Viktor on topic Can't install K2 on joomla.. SQL error

Can't install K2 on joomla.. SQL error

Category: English K2 Community

Try to do this.

In Joomla Admin area go to Extension Manager > Discover (side bar nav)
Click on the "Discover" button at the top.
Find all of the K2 files that weren't installed and select them. Click on "Install" button at the top.
Go back to Extension Manager > Install
Reinstall the K2 SVN version zip file on top of your old installation.
  • marl
  • marl's Avatar
10 Apr 2014 03:24
Can't save items or categories was created by marl

Can't save items or categories

Category: English K2 Community

When I try to save an item or category I get this error message: 1054 Unknown column 'parent' in 'field list' SQL=SELECT `alias`, `link`, `parent`, `id` FROM j25_menu WHERE `link` LIKE '%option=com_k2%id=22%'

I am using joomla 3.2.3
  • Naja
  • Naja's Avatar
04 Apr 2014 05:44
Error 1146 'jos__k2_categories' doesn't exist? was created by Naja

Error 1146 'jos__k2_categories' doesn't exist?

Category: English K2 Community

Hello. InnoDB doesn't work on my server, so I had to change joomla.sql to use MyIsam for the databases. Now when I try to install K2, I get the following error:

An error has occurred.

1146 Table 'XXXX_XXXX.jos_k2_categories' doesn't exist SQL=SHOW FULL COLUMNS FROM `jos_k2_categories`


How do I fix this? Any help would be greatly appreciated.
  • Andreas Kristiansen
  • Andreas Kristiansen's Avatar
31 Mar 2014 12:07 - 31 Mar 2014 12:10
User Error was created by Andreas Kristiansen

User Error

Category: English K2 Community

Hi

When i select Users under K2 I get this error:

0 SQL=SELECT juser.*, k2user.group, k2group.name as groupname FROM hx2fw_users as juser LEFT JOIN hx2fw_k2_users as k2user ON juser.id=k2user.userID LEFT JOIN hx2fw_k2_user_groups as k2group ON k2user.group=k2group.id LEFT JOIN hx2fw_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, 20

Somebody??? :)


Joomla: 3.2.3
K2: 2.6.8
CB: 1.9.1
  • Nuno
  • Nuno's Avatar
29 Mar 2014 03:48
Accessing image property of K2 item was created by Nuno

Accessing image property of K2 item

Category: English K2 Community

Hi,

I'm developing a module that displays a specific number of k2 items based on its category id. I can get those item but I'm not able to access the image on it. When I try $item->image returns the following error:
Notice: Undefined property: stdClass::$image

Here is the object I get from my sql query:
stdClass Object ( [id] => 5 [title] => News test item [alias] => news-test-item [catid] => 4 [published] => 1 [introtext] => <p>Some intro text</p> [fulltext] => [video] => [gallery] => [extra_fields] => [] [extra_fields_search] => [created] => 2014-03-28 21:42:01 [created_by] => 252 [created_by_alias] => [checked_out] => 0 [checked_out_time] => 0000-00-00 00:00:00 [modified] => 0000-00-00 00:00:00 [modified_by] => 0 [publish_up] => 2014-03-28 21:42:01 [publish_down] => 0000-00-00 00:00:00 [trash] => 0 [access] => 1 [ordering] => 1 [featured] => 0 [featured_ordering] => 0 [image_caption] => [image_credits] => [video_caption] => [video_credits] => [hits] => 0 [params] => {"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":""} [metadesc] => [metadata] => robots= author= [metakey] => [plugins] => [language] => * [categoryname] => News-test [categoryid] => 4 [categoryalias] => news-test [categoryparams] => {"inheritFrom":"0","theme":"","num_leading_items":"2","num_leading_columns":"1","leadingImgSize":"Large","num_primary_items":"4","num_primary_columns":"2","primaryImgSize":"Medium","num_secondary_items":"4","num_secondary_columns":"1","secondaryImgSize":"Small","num_links":"4","num_links_columns":"1","linksImgSize":"XSmall","catCatalogMode":"0","catFeaturedItems":"1","catOrdering":"","catPagination":"2","catPaginationResults":"1","catTitle":"1","catTitleItemCounter":"1","catDescription":"1","catImage":"1","catFeedLink":"1","catFeedIcon":"1","subCategories":"1","subCatColumns":"2","subCatOrdering":"","subCatTitle":"1","subCatTitleItemCounter":"1","subCatDescription":"1","subCatImage":"1","itemImageXS":"","itemImageS":"","itemImageM":"","itemImageL":"","itemImageXL":"","catItemTitle":"1","catItemTitleLinked":"1","catItemFeaturedNotice":"0","catItemAuthor":"1","catItemDateCreated":"1","catItemRating":"0","catItemImage":"1","catItemIntroText":"1","catItemIntroTextWordLimit":"","catItemExtraFields":"0","catItemHits":"0","catItemCategory":"1","catItemTags":"1","catItemAttachments":"0","catItemAttachmentsCounter":"0","catItemVideo":"0","catItemVideoWidth":"","catItemVideoHeight":"","catItemAudioWidth":"","catItemAudioHeight":"","catItemVideoAutoPlay":"0","catItemImageGallery":"0","catItemDateModified":"0","catItemReadMore":"1","catItemCommentsAnchor":"1","catItemK2Plugins":"1","itemDateCreated":"1","itemTitle":"1","itemFeaturedNotice":"1","itemAuthor":"1","itemFontResizer":"1","itemPrintButton":"1","itemEmailButton":"1","itemSocialButton":"1","itemVideoAnchor":"1","itemImageGalleryAnchor":"1","itemCommentsAnchor":"1","itemRating":"1","itemImage":"1","itemImgSize":"Large","itemImageMainCaption":"1","itemImageMainCredits":"1","itemIntroText":"1","itemFullText":"1","itemExtraFields":"1","itemDateModified":"1","itemHits":"1","itemCategory":"1","itemTags":"1","itemAttachments":"1","itemAttachmentsCounter":"1","itemVideo":"1","itemVideoWidth":"","itemVideoHeight":"","itemAudioWidth":"","itemAudioHeight":"","itemVideoAutoPlay":"0","itemVideoCaption":"1","itemVideoCredits":"1","itemImageGallery":"1","itemNavigation":"1","itemComments":"1","itemTwitterButton":"1","itemFacebookButton":"1","itemGooglePlusOneButton":"1","itemAuthorBlock":"1","itemAuthorImage":"1","itemAuthorDescription":"1","itemAuthorURL":"1","itemAuthorEmail":"0","itemAuthorLatest":"1","itemAuthorLatestLimit":"5","itemRelated":"1","itemRelatedLimit":"5","itemRelatedTitle":"1","itemRelatedCategory":"0","itemRelatedImageSize":"0","itemRelatedIntrotext":"0","itemRelatedFulltext":"0","itemRelatedAuthor":"0","itemRelatedMedia":"0","itemRelatedImageGallery":"0","itemK2Plugins":"1","catMetaDesc":"","catMetaKey":"","catMetaRobots":"","catMetaAuthor":""} )


What am I missing here?

Any help will be appreciated.
  • Mario Verville
  • Mario Verville's Avatar
26 Mar 2014 00:37
Bug quand je veux ajouter un élément was created by Mario Verville

Bug quand je veux ajouter un élément

Category: Communauté française K2

Quand j'essaie d'ajouter un élément, ça marque:

1064 - Une erreur s'est produite

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 `catid` FROM mv3fx_k2_additional_categories WHERE `itemID` = {intval()}

Peu importe par où je passe.
  • Jose orlando de lima
  • Jose orlando de lima's Avatar
25 Mar 2014 23:58
Erro 404 was created by Jose orlando de lima

Erro 404

Category: English K2 Community

When I go in Parameters, and click on Save or Cancel appears this messangem:


Forbidden

You don't have permission to access /administrator/index.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

How to solve this

Joomla 3.2.3
K2 2.6.8
PHP 5.3.14
MYSQL 5.1.54
  • Nauseous
  • Nauseous's Avatar
22 Mar 2014 20:55
Joomla 3.2.3 content to K2 v2.6.8 Fails every time was created by Nauseous

Joomla 3.2.3 content to K2 v2.6.8 Fails every time

Category: English K2 Community

The error I get:
An error has occurred.

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 ' 1136)' at line 1 SQL=INSERT INTO rrbyp_k2_tags_xref (`id`, `tagID`, `itemID`) VALUES (NULL, , 1136)

Read subject line for versions
1. Optimized Data
2. Cleaned database
3. All Orphans assets, no missing assets, no conflicts, and no missing assets

I followed the import information but still having issues. This seems to be an issue with K2 itself because I've never had any issues with imports until K2.

Help!
  • Alan
  • Alan's Avatar
21 Mar 2014 18:45
K2 Search - Issue - 0-Error:0 was created by Alan

K2 Search - Issue - 0-Error:0

Category: English K2 Community

Hello, I'm building a website, I installed K2, but now I have a problem; When I try to search something on the Search Field, it displays an error (0-Error:0).

"SQL=SELECT DISTINCT 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 QX9JV_K2_ITEMS AS I RIGHT JOIN QX9JV_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 <= '2014-03-21 16:38:53' ) AND ( I.PUBLISH_DOWN = '0000-00-00 00:00:00' OR I.PUBLISH_DOWN >= '2014-03-21 16:38:53' ) AND MATCH(I.TITLE, I.INTROTEXT, I.`FULLTEXT`, I.IMAGE_CAPTION, I.IMAGE_CREDITS, I.VIDEO_CAPTION, I.VIDEO_CREDITS, I.METADESC, I.METAKEY) AGAINST ('""' IN BOOLEAN MODE) ORDER BY I.TITLE LIMIT 0, 10"

I really need some help.

Thanks so much in advance.
Displaying 301 - 320 out of 793 results.
  1. Forum
  3. Search

Powered by Kunena Forum