COMMUNITY FORUM

Keyword
  1. Forum
  3. Search

Advanced Search

Search Results (Searched for: Re Error SQL)

  • 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.
  • Lefteris
  • Lefteris's Avatar
21 Mar 2014 13:50
Replied by Lefteris on topic Warning in Category View mysql.php on line 344

Warning in Category View mysql.php on line 344

Category: English K2 Community

Hi. Have you modified any of the K2 database tables? As i can see in your page, the error is coming from the breadcrumbs module you use there.
  • Gerald Kleinebreil
  • Gerald Kleinebreil's Avatar
14 Mar 2014 11:17
[SOLVED] 1054 Unknown column was created by Gerald Kleinebreil

[SOLVED] 1054 Unknown column

Category: English K2 Community

Hallo,

The following Error i get when i call the USER in K2.

1054 Unknown column 'juser.usertype' in 'order clause' SQL=SELECT juser.*, k2user.group, k2group.name as groupname FROM s9afm_users as juser LEFT JOIN s9afm_k2_users as k2user ON juser.id=k2user.userID LEFT JOIN s9afm_k2_user_groups as k2group ON k2user.group=k2group.id LEFT JOIN s9afm_user_usergroup_map as `map` ON juser.id=map.user_id WHERE juser.id>0 GROUP BY juser.id ORDER BY juser.usertype asc

The site is working fine. Any idea how to fix that?

Thx for help.

Gerald
  • andrea
  • andrea's Avatar
10 Mar 2014 10:37
Error when saving items was created by andrea

Error when saving items

Category: English K2 Community

Hi guys, i have an error when try to saving the items.

"Column count doesn't match value count at row 1 SQL=INSERT INTO `tline_finder_tokens` (`term`,`stem`,`common`,`phrase`,`weight`,`context`) VALUES ('naturbioss', 'naturbioss', 0, 0, 0,6667, 1)
"

How i can fix it?

Joomla: 2.5.19
K2: 2.6.8

Hope your help, thank you.
Regards
A.
  • Lefteris
  • Lefteris's Avatar
07 Mar 2014 18:57
Replied by Lefteris on topic SQL 1064 Error on Front-End Article Save

SQL 1064 Error on Front-End Article Save

Category: English K2 Community

In order to identify such issues in the future you can enable debugging under Joomla! configuration while you are building the site. This should give you more details regarding the error.
  • chomz
  • chomz's Avatar
07 Mar 2014 06:39
Replied by chomz on topic SQL 1064 Error on Front-End Article Save

SQL 1064 Error on Front-End Article Save

Category: English K2 Community

hi... I really dont understand what was wrong .. already tried to put on/off several plugins and modules, switching templates, etc.. no good result at all
finally i decided to re-create the site from zero.. thankfully it's a new site so i only have to rewrite tens k2 articles or so :(
Displaying 301 - 320 out of 788 results.
  1. Forum
  3. Search

Powered by Kunena Forum