COMMUNITY FORUM
Search Results (Searched for: Re Error SQL)
- JoergH
K2 Database Structure
Category: English K2 Community
the db structure isn't stable enough and doesn't work with professional environments like J2EE, hibernate or persistance.
e.g. the K2 item field fulltext is a standard sql word and produces dozens of error messages in an sql-based IDE environment.
Most of the database fields have no default value, but null isn't allowed too. Produces dozens of error messages too.
Sorry, I'm a little bit tiered to solve all this errors in my environment. Could someone fix this db structure please.
Kind regards
Joerg
- Erlend Kraus
Attachment bug: SQL error
Category: English K2 Community
- Lefteris
Attachment bug: SQL error
Category: English K2 Community
- Erlend Kraus
Attachment bug: SQL error
Category: English K2 Community
Warning: Invalid argument supplied for foreach() in public_html/components/com_k2/sef_ext/com_k2.php on line 99
Any idea how to solve it? first i uploaded Attachment everything was ok, then i removed it and replaced and error appeared.
- JoomlaWorks Support Team
Installation Error
Category: Simple Image Gallery PRO
I am using Joomla version 1.5.14. And I have same problem for installing sigp version 2.0.4.
I have done the steps as advised by vinikey, unfortunately, the installation can't work via URL installation method too. Here is the response.
* JFolder::create: Could not create directory
* Unable to create destination
Warning: strpos() [function.strpos]: Offset not contained in string in /home2/xxxx/public_html/6th/libraries/joomla/filesystem/archive/zip.php on line 325
Please advise.
Thank you.
Hi laine!
Can you please confirm that the permissions of the tmp and plugins folder is readable / writable for the user?
This error message
says that the system isn't capable to create the folder.JFolder::create: Could not create directory
Always, this kind of issue has to do with the permissions of the folders!
Please, check the permissions ( must be 777 for the user ).
The plugin is tested under *nix and IIS system for the installation process without any problem, but you have to set up the permissions respect the user who runs the scripts.
The follow steps give us a method 'how to uninstall / install' the sigpro manually
without the use of the joomla
1. First of all, check the table #__plugins if there are any record with
If there are, remove it.name: Simple Image Gallery PRO (by JoomlaWorks)
element: jw_sigpro
2. Remove the files
and the foldersite/plugins/content/jw_sigpro.php
site/plugins/content/jw_sigpro.xml
3. Lets go for the manuall istallsite/plugins/content/jw_sigpro/
4. Unzip the plg_jw_sigpro-v2.0.4_j1.5.zip to your pc
5. Upload the files jw_sigpro.php and jw_sigpro.xml to the folder site/plugins/content
6. Upload the folder jw_sigpro to the folder site/plugins/content
7. Upload the file en-GB.plg_content_jw_sigpro.ini to the folder site/administrator/language/en-GB/
8. Run this sql command ( using phpmyadmin or any other software you have to access the database ). Look out the prefix of the table! I use the "jos_" prefix!
INSERT INTO `jos_plugins` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (NULL, 'Simple Image Gallery PRO (by JoomlaWorks)', 'jw_sigpro', 'content', 0, 0, 0, 0, 0, 0, '0000-00-00 00:00:00', 'galleries_rootfolder=images/stories\npopup_engine=jquery_slimbox\nthb_template=Default\nthb_width=200\nthb_height=160\njpg_quality=75\nshowcaptions=1\nenabledownload=1\ncache_expire_time=120\n');
Thank you!
- rexkramer
Deleted users | error message on article and category display
Category: English K2 Community
Go into myPHPadmin. BACKUP EVERYTHING FIRST!
1. Go to the table for k2_items.
2. Export that table as CSV file... including field names in first line.
3. Open that CSV file in a text editor (NOT IN MS EXCEL)
4. Do a "find and replace" of the deleted UserID with a new UserID and save.
5. Go back to the k2_items table and import your new CSV file .
I am not a Dev for K2, and I have not tested this, as I dont have this issue right now... But im assuming this would work.
Thanks for your thoughts. You might be right. I don´t have a real project, it was a test installation. If i had this issue on a livesite, i would definitly fix it this way.
My previous and initial post should be a possible idea for the K2 Dev team. I think this message (and logical problem) must not occur in a serious K2 powered site.
CU
- CLEMENT
category & item creation problem
Category: English K2 Community
And in Mysqyl tabs doesn't exists !! We must manually create the tabs ??
tablek2category::store failed - Table 'xxxxxbase.jos_k2_categories' doesn't exist SQL=INSERT INTO `jos_k2_categories` ( `id`,`name`,`alias`,`description`,`parent`,`extraFieldsGroup`,`published`,`access`,`ordering`,`params` ) VALUES ( '','hh','hh','','0','0','1','0','','inheritFrom=0\ntheme=\nnum_leading_items=2\nnum_leading_columns=1\nleadingImgSize=Large
I use a 1and1 mutualised server... What is the problem ??
It was nice to use K2, so please help us !!!!!!
Chris Carlo said:I get similar problem.. and it wouldnt' let me import my articles.. This not making sense to because everything seems to be fine on my Local Test Server (WAMP server). I really like this component and I'm sure this going to be great if I can find help on these issues.
From the Dashboard..
click on the add items i get that.
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/tags/tmpl/default.php on line 44
click on the categories... no warnings... but when I try to add a new category and when click on Apply... I get this..
Fatal error: Call to undefined function: mb_internal_encoding() in /home/ccarlo/public_html/administrator/components/com_k2/tables/k2category.php on line 46
click on tags... I get this warning.
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/tags/tmpl/default.php on line 44
click on comments .. I get this warning..
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/comments/tmpl/default.php on line 52
click on users... I get 2 warnings..
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/users/view.html.php on line 88
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/users/tmpl/default.php on line 53
click on user groups.. I get this warnings..
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/usergroups/tmpl/default.php on line 35
click on extra fields... I get 2 warnings..
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/usergroups/tmpl/default.php on line 35
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/extrafields/tmpl/default.php on line 51
click on extra field groups.. I get this warning.
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/extrafieldsgroups/tmpl/default.php on line 36
System information
Check Result
Web Server Apache/1.3.36 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.2 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.27 OpenSSL/0.9.7a
PHP version 4.4.2
MySQL version 4.0.27-standard
GD image library bundled (2.0.28 compatible)
Upload limit 2M
Memory limit
Open remote files (allow url fopen) Yes
Simple Image Gallery Plugin Not installed
Simple Image Gallery PRO Plugin Not installed
AllVideos Plugin Not installed
Directory Permissions
Check Result
media/k2 Writable
media/k2/attachments Writable
media/k2/categories Writable
media/k2/galleries Writable
media/k2/items Writable
media/k2/users Writable
media/k2/videos Writable
cache Writable
I'm sure you guys can help fix or find a solution the issues I have posted, thanks.
-Chris Carlo
- Chris Carlo Enterprises
category & item creation problem
Category: English K2 Community
From the Dashboard..
click on the add items i get that.
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/tags/tmpl/default.php on line 44
click on the categories... no warnings... but when I try to add a new category and when click on Apply... I get this..
Fatal error: Call to undefined function: mb_internal_encoding() in /home/ccarlo/public_html/administrator/components/com_k2/tables/k2category.php on line 46
click on tags... I get this warning.
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/tags/tmpl/default.php on line 44
click on comments .. I get this warning..
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/comments/tmpl/default.php on line 52
click on users... I get 2 warnings..
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/users/view.html.php on line 88
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/users/tmpl/default.php on line 53
click on user groups.. I get this warnings..
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/usergroups/tmpl/default.php on line 35
click on extra fields... I get 2 warnings..
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/usergroups/tmpl/default.php on line 35
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/extrafields/tmpl/default.php on line 51
click on extra field groups.. I get this warning.
Warning: Invalid argument supplied for foreach() in /home/ccarlo/public_html/administrator/components/com_k2/views/extrafieldsgroups/tmpl/default.php on line 36
System information
Check Result
Web Server Apache/1.3.36 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.2 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.27 OpenSSL/0.9.7a
PHP version 4.4.2
MySQL version 4.0.27-standard
GD image library bundled (2.0.28 compatible)
Upload limit 2M
Memory limit
Open remote files (allow url fopen) Yes
Simple Image Gallery Plugin Not installed
Simple Image Gallery PRO Plugin Not installed
AllVideos Plugin Not installed
Directory Permissions
Check Result
media/k2 Writable
media/k2/attachments Writable
media/k2/categories Writable
media/k2/galleries Writable
media/k2/items Writable
media/k2/users Writable
media/k2/videos Writable
cache Writable
I'm sure you guys can help fix or find a solution the issues I have posted, thanks.
-Chris Carlo
- Hankins Development
Error on Category creation....
Category: English K2 Community
Thanks
CH
George Szubinski said:DaniI forgot - I am doing all this locally on my dev box until I deploy but it does raise a good point about deployment:You just need to contact the hosting company support and ask them to enable access to the dll exactly as I have described - it should not pose any problems to other customers at all.georgeDani Carull said:Hi!I'm getting the same error, but i don't have access to the php.ini file because my hosting service don't have de option.Is there another way to solve this problem? modifying something in K2 files?congratulations for this extension! I hope you could help us with this!thks!George Szubinski said:ok resolved now:Wolf - look at www.phpbuilder.com/board/showthread.php?t=10335517 for background.also www.sugarcrm.com/forums/showthread.php?t=39431 for more background.All you need to do is go and edit your php.ini file - search for mbstring and remove the comment to enable it and resave your ini file. Go and restart Apache.georgeGeorge Szubinski said:ok, these seem to be using new functions:mine in the code looks like:mb_internal_encoding("UTF-8");$this->alias = trim(mb_strtolower($this->alias));$this->alias = str_replace('-', ' ', $this->alias);$this->alias = mb_ereg_replace(':space:+', ' ', $this->alias);$this->alias = trim(str_replace(' ', '-', $this->alias));$this->alias = str_replace('.', '', $this->alias);$stripthese = ',|~|!|@|%|^|(|)|<|>|:|;|{|}|[|]|&|`|„|‹|’|‘|“|�|•|›|«|´|»|°';$strips = explode('|', $stripthese);foreach ($strips as $strip) {$this->alias = str_replace($strip, '', $this->alias);So I need someone with mysql knowledge to tell me how I enable this - or is it something we need to enable in phpHELP PLEASE!!!George Szubinski said:I had this and I put it down to the fact that I did a new install and should have done an upgrade...I have now built a brand new Joomla site 1.5.14 and installed simple image and the full K2 from unified installer - all I had was warning because I do not have joofish....So, just tried to add a category, entered a name, pressed save and bang same error as previous poster.Fatal error: Call to undefined function mb_internal_encoding() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\curry2\administrator\components\com_k2\tables\k2category.php on line 46Can we please have some guidance on what we are doing wrong please....!!!!george
- Prasad Sakharkar
Menu Problem and a New Error.
Category: English K2 Community
Just one look at the demo site of K2 hooked me. So I tried to use it. But I am facing strange problems.
I am experienced Joomla Admin but I have to admit that I can't use K2.
I have loaded fresh install of joomla Ver.1.5.14 and installed K2 along with it.
Then I have created a root category named News. Then I created a new item using News category.
I just want to create a menu which will show all items from News Menu. I have created menu as shown below.
But I am getting its output as shown below
Then again I created a "Political Spectrum" category and assigned it to "News" (Parent Category)
Afterwords, when I tried to add item with featured checkbox selected I got following error.
TableK2Item::store failed - Unknown column 'featured_ordering' in 'field list' SQL=INSERT INTO `rk_k2_items` ( `id`,`title`,`alias`,`catid`,`published`,`introtext`,`fulltext`,`image_caption`,`image_credits`,`created`,`created_by`,`created_by_alias`,`publish_up`,`publish_down`,`access`,`ordering`,`featured`,`featured_ordering`,`metadata`,`metadesc`,`metakey`,`params` ) VALUES ( '','Political news','political-news','2','1','
This is political news.
','','','','2009-08-26 18:08:57','62','','2009-08-26 18:08:57','0000-00-00 00:00:00','0','1','1','','robots=\nauthor=','','','catItemTitle=\ncatItemTitleLinked=\ncatItemFeaturedNotice=\ncatItemAuthor=\ncatItemDateCreated=\ncatItemRating=\ncatItemImage=\ncatItemIntroText=\ncatItemExtraFields=\ncatItemHits=\ncatItemCategory=\ncatItemTags=\ncatItemAttachments=\ncatItemAttachmentsCounter=\ncatItemVideo=\ncatItemImageGallery=\ncatItemDateModified=\ncatItemReadMore=\ncatItemCommentsAnchor=\ncatItemK2Plugins=\nitemDateCreated=\nitemTitle=\nitemFeaturedNotice=\nitemAuthor=\nitemFontResizer=\nitemPrintButton=\nitemEmailButton=\nitemSocialButton=\nitemVideoAnchor=\nitemImageGalleryAnchor=\nitemCommentsAnchor=\nitemRating=\nitemImage=\nitemImgSize=\nitemImageMainCaption=\nitemImageMainCredits=\nitemIntroText=\nitemFullText=\nitemExtraFields=\nitemDateModified=\nitemHits=\nitemTwitterLink=\nitemCategory=\nitemTags=\nitemShareLinks=\nitemAttachments=\nitemAttachmentsCounter=\nitemRelated=\nitemRelatedLimit=\nitemVideo=\nitemVideoCaption=\nitemVideoCredits=\nitemImageGallery=\nitemNavigation=\nitemComments=\nitemAuthorBlock=\nitemAuthorImage=\nitemAuthorDescription=\nitemAuthorURL=\nitemAuthorEmail=\nitemAuthorLatest=\nitemAuthorLatestLimit=\nitemK2Plugins=\n\n' )
Can anyone guide me here. I just want to show all the items in various categories in respective menu. I am using New Menu -> K2 -> Item listing -> Categories but still No items are appearing. I can only see category name but If I click on it nothing happens.
- FidelGonzales
Install Issues
Category: English K2 Community
Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering
DB function failed with error number 2006
MySQL server has gone away SQL=SELECT ordering AS value, name AS text FROM jos_k2_categories ORDER BY ordering
- Mationjv
Install Issues
Category: English K2 Community
JInstaller::install: SQL Error. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_k2_attachments` ( `id` int(11) NOT NULL auto_increment, `itemID` int(11) NOT NULL, `filename` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `titleAttribute` text NOT NULL, `hits` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `itemID` (`itemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_k2_attachments` (
`id` int(11) NOT NULL auto_increment,
`itemID` int(11) NOT NULL,
`filename` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`titleAttribute` text NOT NULL,
`hits` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `itemID` (`itemID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_k2_attachments` ( `id` int(11) NOT NULL auto_increment, `itemID` int(11) NOT NULL, `filename` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `titleAttribute` text NOT NULL, `hits` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `itemID` (`itemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_k2_attachments` (
`id` int(11) NOT NULL auto_increment,
`itemID` int(11) NOT NULL,
`filename` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`titleAttribute` text NOT NULL,
`hits` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `itemID` (`itemID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering
Any help would be greatly appreciated
- Dodge
Front-end article stays checked-in?
Category: English K2 Community
Edward A Parker said:I had no crtical content in my pre-release install so I unstalled the component and started fresh by installing the full 2.0 version, so improper upgrade is not an issue.. Also.. I see a "SUBMIT" button, and a "CLEAR ALL FORM FIELDS" button, but I cannot find a "CLOSE" button (or [X] or anything else that resembles this. My site is: www.twintierslive.com. Feel free to become a member and use the site. I would love to have your input.. Thanks!!
Lefteris Kavadas said:Hi. Please make sure you have followed the instructions for updating from prerelease version to the stable one. The error indicates that you have not run the update routine. Please try to to follow the update instructions and let me know what happens.Edward A Parker said:Has there been any word on this.. Of all the "bugs" I have found in the latest version, this is by far the toughest one for me to deal with. Is it connected to the fact that after submitting from front end, the editor just stays there rather than reverting to the previous page? Also... If an author checks the box "featured" on the front end, they are greeted with the following error:TableK2Item::store failed - Unknown column 'featured_ordering' in 'field list' SQL=INSERT INTO `pws_k2_items` ( `id`,`title`,`alias`,`catid`,`published`,`introtext`,`fulltext`,`image_caption`,`image_credits`,`created`,`created_by`,`created_by_alias`,`publish_up`,`publish_down`,`access`,`ordering`,`featured`,`featured_ordering` ) VALUES ( '','Test 2','test-2','5','1','Test Article 2','','','','2009-08-19 19:40:58','67','','2009-08-19 14:40:58','0000-00-00 00:00:00','0','2','1','' )And the article doesn't load. I can live with that, but it does seem as though this could be fixed
- Edward A Parker
Front-end article stays checked-in?
Category: English K2 Community
Thanks!!
Lefteris Kavadas said:Hi. Please make sure you have followed the instructions for updating from prerelease version to the stable one. The error indicates that you have not run the update routine. Please try to to follow the update instructions and let me know what happens.Edward A Parker said:Has there been any word on this.. Of all the "bugs" I have found in the latest version, this is by far the toughest one for me to deal with. Is it connected to the fact that after submitting from front end, the editor just stays there rather than reverting to the previous page? Also... If an author checks the box "featured" on the front end, they are greeted with the following error:TableK2Item::store failed - Unknown column 'featured_ordering' in 'field list' SQL=INSERT INTO `pws_k2_items` ( `id`,`title`,`alias`,`catid`,`published`,`introtext`,`fulltext`,`image_caption`,`image_credits`,`created`,`created_by`,`created_by_alias`,`publish_up`,`publish_down`,`access`,`ordering`,`featured`,`featured_ordering` ) VALUES ( '','Test 2','test-2','5','1','Test Article 2','','','','2009-08-19 19:40:58','67','','2009-08-19 14:40:58','0000-00-00 00:00:00','0','2','1','' )And the article doesn't load. I can live with that, but it does seem as though this could be fixed
- Dana Murphy
error message on creation of item
Category: English K2 Community
I just went to create my first K2 item and got this:
TableK2Item::store failed - Unknown column 'featured_ordering' in 'field list' SQL=INSERT INTO `jos_k2_items` ( `id`,`title`,`alias`,`catid`,`published`,`introtext`,`fulltext`,`image_caption`,`image_credits`,`created`,`created_by`,`created_by_alias`,`publish_up`,`publish_down`,`access`,`ordering`,`featured`,`featured_ordering`,`metadata`,`metadesc`,`metakey`,`params` ) VALUES ( '','New Passap','newpase6','3','1','','','','','2009-08-20 22:32:27','63','Dana','2009-08-20 22:32:27','0000-00-00 00:00:00','0','1','1','','robots=\nauthor=','Passap E6000','new, item, knitting machine','catItemTitle=\ncatItemTitleLinked=\ncatItemFeaturedNotice=\ncatItemAuthor=\ncatItemDateCreated=\ncatItemRating=\ncatItemImage=\ncatItemIntroText=\ncatItemExtraFields=\ncatItemHits=\ncatItemCategory=\ncatItemTags=\ncatItemAttachments=\ncatItemAttachmentsCounter=\ncatItemVideo=\ncatItemImageGallery=\ncatItemDateModified=\ncatItemReadMore=\ncatItemCommentsAnchor=\ncatItemK2Plugins=\nitemDateCreated=\nitemTitle=\nitemFeaturedNotice=\nitemAuthor=\nitemFontResizer=\nitemPrintButton=\nitemEmailButton=\nitemSocialButton=\nitemVideoAnchor=\nitemImageGalleryAnchor=\nitemCommentsAnchor=\nitemRating=\nitemImage=\nitemImgSize=\nitemImageMainCaption=\nitemImageMainCredits=\nitemIntroText=\nitemFullText=\nitemExtraFields=\nitemDateModified=\nitemHits=\nitemTwitterLink=\nitemCategory=\nitemTags=\nitemShareLinks=\nitemAttachments=\nitemAttachmentsCounter=\nitemRelated=\nitemRelatedLimit=\nitemVideo=\nitemVideoCaption=\nitemVideoCredits=\nitemImageGallery=\nitemNavigation=\nitemComments=\nitemAuthorBlock=\nitemAuthorImage=\nitemAuthorDescription=\nitemAuthorURL=\nitemAuthorEmail=\nitemAuthorLatest=\nitemAuthorLatestLimit=\nitemK2Plugins=\n\n' )
clues?
Thx.
- Lefteris
Front-end article stays checked-in?
Category: English K2 Community
Edward A Parker said:Has there been any word on this.. Of all the "bugs" I have found in the latest version, this is by far the toughest one for me to deal with. Is it connected to the fact that after submitting from front end, the editor just stays there rather than reverting to the previous page? Also... If an author checks the box "featured" on the front end, they are greeted with the following error:
TableK2Item::store failed - Unknown column 'featured_ordering' in 'field list' SQL=INSERT INTO `pws_k2_items` ( `id`,`title`,`alias`,`catid`,`published`,`introtext`,`fulltext`,`image_caption`,`image_credits`,`created`,`created_by`,`created_by_alias`,`publish_up`,`publish_down`,`access`,`ordering`,`featured`,`featured_ordering` ) VALUES ( '','Test 2','test-2','5','1','Test Article 2','','','','2009-08-19 19:40:58','67','','2009-08-19 14:40:58','0000-00-00 00:00:00','0','2','1','' )
And the article doesn't load. I can live with that, but it does seem as though this could be fixed
- Edward A Parker
Front-end article stays checked-in?
Category: English K2 Community
TableK2Item::store failed - Unknown column 'featured_ordering' in 'field list' SQL=INSERT INTO `pws_k2_items` ( `id`,`title`,`alias`,`catid`,`published`,`introtext`,`fulltext`,`image_caption`,`image_credits`,`created`,`created_by`,`created_by_alias`,`publish_up`,`publish_down`,`access`,`ordering`,`featured`,`featured_ordering` ) VALUES ( '','Test 2','test-2','5','1','Test Article 2','','','','2009-08-19 19:40:58','67','','2009-08-19 14:40:58','0000-00-00 00:00:00','0','2','1','' )
And the article doesn't load. I can live with that, but it does seem as though this could be fixed
- Kaye Patrick
mod_k2_comments Top Commenter SQL Error
Category: English K2 Community
This can be fixed by modifying /modules/mod_k2_comments/helper.php as follows:
around line 111, find
$query = "SELECT COUNT(id) as counter, userName, userID, commentEmail FROM #__k2_comments"." WHERE userID > 0"." AND published = 1";
" GROUP BY userID ORDER BY counter DESC";
and replace with
$query = "SELECT COUNT(id) as counter, userName, userID, commentEmail FROM #__k2_comments"." WHERE userID > 0"." AND published = 1"." GROUP BY userID ORDER BY counter DESC";
this replaces one semicolon with a period before "GROUP BY"
- iImagine 'n' iKnow Ltd.
Error on Category creation....
Category: English K2 Community
I forgot - I am doing all this locally on my dev box until I deploy but it does raise a good point about deployment:
You just need to contact the hosting company support and ask them to enable access to the dll exactly as I have described - it should not pose any problems to other customers at all.
george
Dani Carull said:Hi!
I'm getting the same error, but i don't have access to the php.ini file because my hosting service don't have de option.
Is there another way to solve this problem? modifying something in K2 files?
congratulations for this extension! I hope you could help us with this!
thks!
George Szubinski said:ok resolved now:Wolf - look at www.phpbuilder.com/board/showthread.php?t=10335517 for background.also www.sugarcrm.com/forums/showthread.php?t=39431 for more background.All you need to do is go and edit your php.ini file - search for mbstring and remove the comment to enable it and resave your ini file. Go and restart Apache.georgeGeorge Szubinski said:ok, these seem to be using new functions:mine in the code looks like:mb_internal_encoding("UTF-8");$this->alias = trim(mb_strtolower($this->alias));$this->alias = str_replace('-', ' ', $this->alias);$this->alias = mb_ereg_replace(':space:+', ' ', $this->alias);$this->alias = trim(str_replace(' ', '-', $this->alias));$this->alias = str_replace('.', '', $this->alias);$stripthese = ',|~|!|@|%|^|(|)|<|>|:|;|{|}|[|]|&|`|„|‹|’|‘|“|�|•|›|«|´|»|°';$strips = explode('|', $stripthese);foreach ($strips as $strip) {$this->alias = str_replace($strip, '', $this->alias);So I need someone with mysql knowledge to tell me how I enable this - or is it something we need to enable in phpHELP PLEASE!!!George Szubinski said:I had this and I put it down to the fact that I did a new install and should have done an upgrade...I have now built a brand new Joomla site 1.5.14 and installed simple image and the full K2 from unified installer - all I had was warning because I do not have joofish....So, just tried to add a category, entered a name, pressed save and bang same error as previous poster.Fatal error: Call to undefined function mb_internal_encoding() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\curry2\administrator\components\com_k2\tables\k2category.php on line 46Can we please have some guidance on what we are doing wrong please....!!!!george
- Dani Carull
Error on Category creation....
Category: English K2 Community
I'm getting the same error, but i don't have access to the php.ini file because my hosting service don't have de option.
Is there another way to solve this problem? modifying something in K2 files?
congratulations for this extension! I hope you could help us with this!
thks!
George Szubinski said:ok resolved now:Wolf - look at www.phpbuilder.com/board/showthread.php?t=10335517 for background.also www.sugarcrm.com/forums/showthread.php?t=39431 for more background.All you need to do is go and edit your php.ini file - search for mbstring and remove the comment to enable it and resave your ini file. Go and restart Apache.georgeGeorge Szubinski said:ok, these seem to be using new functions:mine in the code looks like:mb_internal_encoding("UTF-8");$this->alias = trim(mb_strtolower($this->alias));$this->alias = str_replace('-', ' ', $this->alias);$this->alias = mb_ereg_replace(':space:+', ' ', $this->alias);$this->alias = trim(str_replace(' ', '-', $this->alias));$this->alias = str_replace('.', '', $this->alias);$stripthese = ',|~|!|@|%|^|(|)|<|>|:|;|{|}|[|]|&|`|„|‹|’|‘|“|�|•|›|«|´|»|°';$strips = explode('|', $stripthese);foreach ($strips as $strip) {$this->alias = str_replace($strip, '', $this->alias);So I need someone with mysql knowledge to tell me how I enable this - or is it something we need to enable in phpHELP PLEASE!!!George Szubinski said:I had this and I put it down to the fact that I did a new install and should have done an upgrade...I have now built a brand new Joomla site 1.5.14 and installed simple image and the full K2 from unified installer - all I had was warning because I do not have joofish....So, just tried to add a category, entered a name, pressed save and bang same error as previous poster.Fatal error: Call to undefined function mb_internal_encoding() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\curry2\administrator\components\com_k2\tables\k2category.php on line 46Can we please have some guidance on what we are doing wrong please....!!!!george