Keyword

Advanced Search

Search Results (Searched for: Re Error SQL)

  • william white
  • william white's Avatar
22 Aug 2010 14:01

Fatal error on Import Joomla Content - memory allocation

Category: English K2 Community

I would try breaking the import into smaller chunks. As there is not a way to do this with default k2, i would first try:
phpmyadmin - export to csv, bring the file to local machine
use xcel or local mysql, or other database program to split the file into multiple csv files
then i would use www.individual-it.net/en/Joomla/ to import the articles to items.
If your articles are divided into groups by joomla section and/or category that may be a way to use phpmyadmin to break them into chunks
  • Belelros
  • Belelros's Avatar
11 Aug 2010 14:57
Too many images! Handle it! was created by Belelros

Too many images! Handle it!

Category: Simple Image Gallery PRO

Hi!

I'm having some problems with this plugin. When I try to put a Gallery which have 70+ images, the article goes extremely slow and even show SQL errors. If I disable the gallery (removing the line) it shows correctly.

Also, some of them were showed in black but if you click in them, they appear correctly.

Do you know how to solve this?

Thanks and regards
  • iImagine 'n' iKnow Ltd.
  • iImagine 'n' iKnow Ltd.'s Avatar
10 Aug 2010 06:56

Issue with K2 Tables: ##Error message: The used table type doesn't support FULLTEXT indexes

Category: English K2 Community

Apologies,

I have researched further. This is a known MySql bug.

Looks like I need to specify the Engine type as MYISAM.

See

george
  • iImagine 'n' iKnow Ltd.
  • iImagine 'n' iKnow Ltd.'s Avatar
10 Aug 2010 00:31

Issue with K2 Tables: ##Error message: The used table type doesn't support FULLTEXT indexes

Category: English K2 Community

AllI use XCloner to backup my joomla sites and restore to a different host, been using this for a couple of years. However, before my next move I checked out a site I built on my local pc, setup another test directory, another new DB (empty) and ran a restore on a backup I had taken. XCloner first unzips all the joomla directory and data structures, then in the new target database it builds the joomla database.All worked as expected except ALL my K2 tables failed - see below.Can anyone comment as to why K2 doesnt support FULL TEXT but more importantly what I need to do to workaround this problem.ThanksGeorgeXCloner Automatic Restore! Configuration updated! There were some errors while importing the database:

##Mysql Query: ######## CREATE TABLE `jos_k2_items` ( `id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL, `alias` varchar(255) default NULL,
`catid` int(11) NOT NULL, `published` smallint(6) NOT NULL default '0',
`introtext` text NOT NULL, `fulltext` text NOT NULL, `video` text,
`gallery` varchar(255) default NULL, `extra_fields` text character set
utf8 collate utf8_unicode_ci, `extra_fields_search` text NOT NULL,
`created` datetime NOT NULL, `created_by` int(11) NOT NULL default '0',
`created_by_alias` varchar(255) NOT NULL, `checked_out` int(10)
unsigned NOT NULL, `checked_out_time` datetime NOT NULL, `modified`
datetime NOT NULL, `modified_by` int(11) NOT NULL default '0',
`publish_up` datetime NOT NULL, `publish_down` datetime NOT NULL,
`trash` smallint(6) NOT NULL default '0', `access` int(11) NOT NULL
default '0', `ordering` int(11) NOT NULL default '0', `featured`
smallint(6) NOT NULL default '0', `featured_ordering` int(11) NOT NULL
default '0', `image_caption` text NOT NULL, `image_credits`
varchar(255) NOT NULL, `video_caption` text NOT NULL, `video_credits`
varchar(255) NOT NULL, `hits` int(10) unsigned NOT NULL, `params` text
NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL,
`metakey` text NOT NULL, `plugins` text NOT NULL, PRIMARY KEY (`id`),
KEY `item` (`published`,`publish_up`,`publish_down`,`trash`,`access`),
KEY `catid` (`catid`), KEY `created_by` (`created_by`), KEY
`ordering` (`ordering`), KEY `featured` (`featured`), KEY
`featured_ordering` (`featured_ordering`), KEY `hits` (`hits`), KEY
`created` (`created`), FULLTEXT KEY `search`
(`title`,`introtext`,`fulltext`,`extra_fields_search`,`image_caption`,`image_credits`,`video_caption`,`video_credits`,`metadesc`,`metakey`),
FULLTEXT KEY `title` (`title`)); ######## ##Error message: The used table type doesn't support FULLTEXT indexes

##Mysql Query: ######## INSERT INTO jos_k2_items VALUES
('1','Dedication','dedication','1','1','<p style=\"text-align:
center;\">\r\n <span style=\"font-size: 24px;\"><span
style=\"color: rgb(0, 0, 139);\">Dedicated to
James</span></span></p>\r\n<p>\r\n {loadposition
fps1}</p>\r\n<p style=\"text-align: center;\">\r\n <span
style=\"font-size: 24px;\"><strong><span style=\"color:
rgb(0, 0, 139);\">IN MEMORY</span> <span style=\"color:
rgb(0, 0, 139);\">OF</span> <span style=\"color: rgb(0, 0,
139);\">JAMES JERZY
SZUBINSKI</span></strong></span></p>\r\n<p
style=\"text-align: center;\">\r\n <span style=\"font-size:
24px;\"><strong><span style=\"color: rgb(0, 0,
139);\">1973 –
2007</span></strong></span><strong><span
_fck_bookmark=\"1\" style=\"display: none;\">
</span></strong></p>\r\n<p style=\"text-align:
center;\">\r\n <span style=\"color: rgb(0, 0, 128);\">'Those we
love don’t go away<br />\r\n <br />\r\n they walk beside us
everyday<br />\r\n <br />\r\n Forever In our
Hearts'</span></p>\r\n<p>\r\n <span
_fck_bookmark=\"1\" style=\"display: none;\">
</span></p>\r\n<p align=\"left\">\r\n {audio
autostart}images/stories/music/09 - U2 - Beautiful
Day.mp3{/audio}</p>\r\n<p align=\"left\">\r\n On the
20<sup>th</sup> February 1973 my wife Janis gave birth to a
beautiful boy, we called him James. I remember thinking how wonderful
life was and how it was a beautiful day. We had a great family were very
close, caring and loving. James and his sister Joanne have always been
very special to Janis and me. On the 5<sup>th</sup> June
2007, after a particularly nasty accident at home, God relieved James of
his pain and he died.I remember looking out of the window at the
hospital, at all the people busy going to work and thinking to myself –
it is a beautiful day.</p>\r\n<p align=\"left\">\r\n Janis,
Joanne, George and Dave would like to thank the Redditch A&E
department and to pay a huge tribute to the wonderful ICU teams at the
John Radcliffe Hospital who worked hard attempting to save James' life.
Their professionalism and compassion is simply
remarkable.</p>\r\n<p align=\"left\">\r\n We would like to
thank everyone who were so generous with their financial donations. The
total amount of money donated was £784.50 and was sent to the John
Radcliffe Hospital.</p>\r\n<p align=\"left\">\r\n If anyone
has problems with this website or needs to contact me - <a
href=\"mailto:[email protected]\">email
me</a></p>','','','','[]','','2010-07-14
23:54:43','62','','0','0000-00-00 00:00:00','2010-07-29
18:22:33','62','2010-07-14 23:54:43','0000-00-00
00:00:00','0','0','1','0','0','','','','','1','catItemTitle=0\r\ncatItemTitleLinked=0\r\ncatItemFeaturedNotice=0\r\ncatItemAuthor=0\r\ncatItemDateCreated=0\r\ncatItemRating=0\r\ncatItemImage=0\r\ncatItemIntroText=1\r\ncatItemExtraFields=0\r\ncatItemHits=0\r\ncatItemCategory=0\r\ncatItemTags=\r\ncatItemAttachments=\r\ncatItemAttachmentsCounter=\r\ncatItemVideo=\r\ncatItemVideoWidth=\r\ncatItemVideoHeight=\r\ncatItemVideoAutoPlay=\r\ncatItemImageGallery=\r\ncatItemDateModified=\r\ncatItemReadMore=0\r\ncatItemCommentsAnchor=\r\ncatItemK2Plugins=\r\nitemDateCreated=\r\nitemTitle=\r\nitemFeaturedNotice=\r\nitemAuthor=\r\nitemFontResizer=\r\nitemPrintButton=\r\nitemEmailButton=\r\nitemSocialButton=\r\nitemVideoAnchor=\r\nitemImageGalleryAnchor=\r\nitemCommentsAnchor=\r\nitemRating=\r\nitemImage=\r\nitemImgSize=\r\nitemImageMainCaption=\r\nitemImageMainCredits=\r\nitemIntroText=\r\nitemFullText=\r\nitemExtraFields=\r\nitemDateModified=\r\nitemHits=\r\nitemTwitterLink=\r\nitemCategory=\r\nitemTags=\r\nitemShareLinks=\r\nitemAttachments=\r\nitemAttachmentsCounter=\r\nitemRelated=\r\nitemRelatedLimit=\r\nitemVideo=\r\nitemVideoWidth=\r\nitemVideoHeight=\r\nitemVideoAutoPlay=\r\nitemVideoCaption=\r\nitemVideoCredits=\r\nitemImageGallery=\r\nitemNavigation=\r\nitemComments=\r\nitemAuthorBlock=\r\nitemAuthorImage=\r\nitemAuthorDescription=\r\nitemAuthorURL=\r\nitemAuthorEmail=\r\nitemAuthorLatest=\r\nitemAuthorLatestLimit=\r\nitemK2Plugins=\r\n\r\n','','robots=\r\nauthor=','','');
######## ##Error message: Table 'jjtest.jos_k2_items' doesn't exist

##Mysql Query: ######## INSERT INTO jos_k2_items VALUES ('2','Dedicate
2','dedicate-2','1','1','<p>\r\n This site is dedicated to you my
son, my very best friend.</p>\r\n<p align=\"left\">\r\n
James was a terrific guy, full of boundless energy and incredible
humour. He worked hard, was highly respected and had many, many friends.
He was married to Sarah and has two beautiful children – Chloe and
Kai.</p>\r\n<p align=\"left\">\r\n His best mate was Dave
who later on in their friendship fell in love with and married James'
sister Joanne. Dave and Jo’s children Abbie and Ellis miss those happy
days with their favourite uncle James and their cousins and pals Chloe
and Kai.</p>\r\n<p align=\"left\">\r\n James’ funeral was
held at Redditch Crematorium Chapel on the 15<sup>th</sup>
June, his ashes were scattered by Sarah by the only tree in Arrow Mill’s
grounds in October. A plaque in memory of James has been placed by a
beautiful tree in St Leonard’s cemetery Boeley (close to a bench) as
part of a small dedication service during March 2008. If you are in the
area please pay James a visit.</p>\r\n<p align=\"left\">\r\n
This site is here for all his friends and family to view, share in
happier memories and leave their thoughts.</p>\r\n<p
align=\"left\">\r\n </p>\r\n<p align=\"left\">\r\n
</p>\r\n<p>\r\n </p>\r\n<table border=\"0\"
style=\"height: 132px;\" width=\"817\">\r\n <tbody>\r\n
<tr>\r\n <td>\r\n </td>\r\n <td>\r\n
</td>\r\n </tr>\r\n
</tbody>\r\n</table>','','','','[]','','2010-07-15
00:01:17','62','','0','0000-00-00 00:00:00','2010-07-15
17:30:14','62','2010-07-15 00:01:17','0000-00-00
00:00:00','0','0','2','0','0','','','','','0','catItemTitle=0\r\ncatItemTitleLinked=0\r\ncatItemFeaturedNotice=\r\ncatItemAuthor=0\r\ncatItemDateCreated=0\r\ncatItemRating=0\r\ncatItemImage=0\r\ncatItemIntroText=\r\ncatItemExtraFields=0\r\ncatItemHits=0\r\ncatItemCategory=0\r\ncatItemTags=0\r\ncatItemAttachments=0\r\ncatItemAttachmentsCounter=0\r\ncatItemVideo=0\r\ncatItemVideoWidth=\r\ncatItemVideoHeight=\r\ncatItemVideoAutoPlay=\r\ncatItemImageGallery=\r\ncatItemDateModified=0\r\ncatItemReadMore=0\r\ncatItemCommentsAnchor=0\r\ncatItemK2Plugins=\r\nitemDateCreated=\r\nitemTitle=\r\nitemFeaturedNotice=\r\nitemAuthor=\r\nitemFontResizer=\r\nitemPrintButton=\r\nitemEmailButton=\r\nitemSocialButton=\r\nitemVideoAnchor=\r\nitemImageGalleryAnchor=\r\nitemCommentsAnchor=\r\nitemRating=\r\nitemImage=\r\nitemImgSize=\r\nitemImageMainCaption=\r\nitemImageMainCredits=\r\nitemIntroText=\r\nitemFullText=\r\nitemExtraFields=\r\nitemDateModified=\r\nitemHits=\r\nitemTwitterLink=\r\nitemCategory=\r\nitemTags=\r\nitemShareLinks=\r\nitemAttachments=\r\nitemAttachmentsCounter=\r\nitemRelated=\r\nitemRelatedLimit=\r\nitemVideo=\r\nitemVideoWidth=\r\nitemVideoHeight=\r\nitemVideoAutoPlay=\r\nitemVideoCaption=\r\nitemVideoCredits=\r\nitemImageGallery=\r\nitemNavigation=\r\nitemComments=\r\nitemAuthorBlock=\r\nitemAuthorImage=\r\nitemAuthorDescription=\r\nitemAuthorURL=\r\nitemAuthorEmail=\r\nitemAuthorLatest=\r\nitemAuthorLatestLimit=\r\nitemK2Plugins=\r\n\r\n','','robots=\r\nauthor=','','');
######## ##Error message: Table 'jjtest.jos_k2_items' doesn't exist

##Mysql Query: ######## INSERT INTO jos_k2_items VALUES ('3','Messages to
James','messages-to-james','2','1','<p>\r\n Please leave your
messages to James here:<br />\r\n
</p>','','','','[]','','2010-07-15
18:27:05','62','','0','0000-00-00 00:00:00','0000-00-00
00:00:00','0','2010-07-15 18:27:05','0000-00-00
00:00:00','0','0','1','0','0','','','','','13','catItemTitle=\r\ncatItemTitleLinked=\r\ncatItemFeaturedNotice=\r\ncatItemAuthor=\r\ncatItemDateCreated=\r\ncatItemRating=\r\ncatItemImage=\r\ncatItemIntroText=\r\ncatItemExtraFields=\r\ncatItemHits=\r\ncatItemCategory=\r\ncatItemTags=\r\ncatItemAttachments=\r\ncatItemAttachmentsCounter=\r\ncatItemVideo=\r\ncatItemVideoWidth=\r\ncatItemVideoHeight=\r\ncatItemVideoAutoPlay=\r\ncatItemImageGallery=\r\ncatItemDateModified=\r\ncatItemReadMore=\r\ncatItemCommentsAnchor=\r\ncatItemK2Plugins=\r\nitemDateCreated=\r\nitemTitle=\r\nitemFeaturedNotice=\r\nitemAuthor=\r\nitemFontResizer=\r\nitemPrintButton=\r\nitemEmailButton=\r\nitemSocialButton=\r\nitemVideoAnchor=\r\nitemImageGalleryAnchor=\r\nitemCommentsAnchor=\r\nitemRating=\r\nitemImage=\r\nitemImgSize=\r\nitemImageMainCaption=\r\nitemImageMainCredits=\r\nitemIntroText=\r\nitemFullText=\r\nitemExtraFields=\r\nitemDateModified=\r\nitemHits=\r\nitemTwitterLink=\r\nitemCategory=\r\nitemTags=\r\nitemShareLinks=\r\nitemAttachments=\r\nitemAttachmentsCounter=\r\nitemRelated=\r\nitemRelatedLimit=\r\nitemVideo=\r\nitemVideoWidth=\r\nitemVideoHeight=\r\nitemVideoAutoPlay=\r\nitemVideoCaption=\r\nitemVideoCredits=\r\nitemImageGallery=\r\nitemNavigation=\r\nitemComments=\r\nitemAuthorBlock=\r\nitemAuthorImage=\r\nitemAuthorDescription=\r\nitemAuthorURL=\r\nitemAuthorEmail=\r\nitemAuthorLatest=\r\nitemAuthorLatestLimit=\r\nitemK2Plugins=\r\n\r\n','','robots=\r\nauthor=','','');
######## ##Error message: Table 'jjtest.jos_k2_items' doesn't exist

##Mysql Query: ######## CREATE TABLE `jos_k2_tags` ( `id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL, `published` smallint(6) NOT NULL default
'0', PRIMARY KEY (`id`), KEY `published` (`published`), FULLTEXT KEY
`name` (`name`)); ######## ##Error message: The used table type doesn't support FULLTEXT indexes
  • Georgi Maleshkov
  • Georgi Maleshkov's Avatar
01 Aug 2010 09:34

K2 Information page and Content Image upload - returns blank pages

Category: English K2 Community

Dear Members,i try to install K2 component on our site, after the installation don't have any error messages, but when i try to see the K2 information page - server redirect me to blank page, same when i try to upload a image. System information:FreeBSD 7.2-RELEASEPHP ver. 5.2.9Joomla! 1.5.14 StableApache/2.2.11MySQL 5.0.81Thank you very much for your suggestions.With regards,G.M.
  • Mark Schultz
  • Mark Schultz's Avatar
26 Jul 2010 11:40

[REOPENED] local domain prepended to url before 'use remote video' url

Category: English K2 Community

I want to stream some videos from another server. Issue can be reproduced thus:1. create an item2. Under video tab, select "browse server/use remote video" tab3. Enter URL of remote video.4. Save item5. Preview of video fails with error.Instead of  remotedomain.com/path/video.flvthe video URL supplied by K2 is localdomain.net/http://remotedomain.com/path/video.flvSo far I have found:The plugin code is being stored properly in the items table in the database:
{flvremote}remotedomain.com/path/video.flv{/flvremote}

However the flvplayer rendered on the page sees this address instead:
localdomain.net/http://remotedomain.com/path/video.flv

when I disable the plugin so the page will reveal the plugin code instead of the player, I see:
{flvremote}localdomain.net/http://remotedomain.com/path/video.flv{/flvremote}

so though the plugin code is being stored in the database properly, it
apparently is being delivered by k2 improperly to the plugin.I don't know where to go from here to troubleshoot further. Any help from you K2 aficionados is greatly appreciated.An example can be seen here at dev site: nvcacademy.net/2Using K2 2.3 fresh installallvideos plugin 3.3Joomla 1.5.17PHP 5.2.12mySQL 5.0.91-communityApache 2.2.14This issue was originally reported in the advanced discussion, I moved it here because it does appear to be a bug.
  • George Cox
  • George Cox's Avatar
16 Jul 2010 22:45
Warning message after updating to 2.3 was created by George Cox

Warning message after updating to 2.3

Category: English K2 Community

This is my first time posting, I hope I am in the right area.  I also searched but couldn't find anything relating to my problem.After updating to 2.3 I keep getting 2 to 4 of these warnings messages across the top of the category pages on the front end of my site. Warning: is_array() [function.is-array]:
Only one argument expected in /home/website/public_html/plugins/system/nonumberelements/helpers/assignments.php
on line 447.There weren't any error messages during the update and everything seems to be working correctly except for these warning messages.  I am on a hosted server with Joomla 1.5.15, PHP 5.2.12 and MySQL 5.0.90.  Any help would be appreciated.
  • kabeza
  • kabeza's Avatar
08 Jul 2010 14:07

bUG? Error k2 attachment renames a file when uploaded

Category: English K2 Community

I finally did:

1- backup to jos_k2_*** tables in phpmyadmin
2- backup media/k2 folder in ftp
3- removed k2 v2.2
4- installed k2 v2.3
5- restored sql backup from point 1 (restored the original jos_k2_*** tables)
6- removed .txt from each media/k2/attachtments file (you can do this in your pc with a multiple renamer software)
7- uploaded k2 folder to media/k2 in ftp (overwrote everything)
8- removed .txt manually from each record in the jos_k2_attachtments table

It is a long and kinda complicated process, but I guess it is working fine now
PS: Software still shows v.2.2 in the control panel... I guess we'll have to do another upgrade soon


Vassilis said:Hi Lefteris, i still have teh same problem.
In every K2 site i create.
From every browser and with the latest version...
Any solution plz?

Lefteris Kavadas said:Hi. This is a mime detection problem. It seems that the class.upload.php fails to detect the correct mime type on your system. You can try: 1. Update K2 to it's latest version. It also updates the specific class to it's latest version. 2. Upload the file from a different browser.
  • william white
  • william white's Avatar
05 Jul 2010 06:53
Replied by william white on topic Category creation error

Category creation error

Category: English K2 Community

YOu can verify this with phpmyadmin
it should say MySQL charset: UTF-8 when you look at the database
  • Jonathan Baker
  • Jonathan Baker's Avatar
02 Jul 2010 18:16
Blank Page in Front End was created by Jonathan Baker

Blank Page in Front End

Category: English K2 Community

Anytime I try to add or edit and item in the front end, all I get when I click the link is an oversized lightbox appears with a blank page inside, no source and no error reporting either (error reporting is set to maximum). I also have the same problem when trying to moderate the comments for the page. I would like to fix both the blank page issue as well as the oversized lightbox window.
I am running the last version of K2 v.2.3. Here is my server information:


Check
Result


 


Web Server
Apache/2.2.14 (Ubuntu)

PHP version
5.3.2-1ubuntu4.2

MySQL version
5.1.41-3ubuntu12.3

GD image library
2.0

Multibyte string support
Enabled

Upload limit
2M

Memory limit
128M

Open remote files (allow url fopen)
Yes






I am new to K2 and I would greatly appreciate any feedback on the issue. I have browsed through the forum and I haven't found a solution to my problem.
  • giovanni cortelezzi
  • giovanni cortelezzi's Avatar
30 Jun 2010 11:09
I have any K2 tables in my DB was created by giovanni cortelezzi

I have any K2 tables in my DB

Category: English K2 Community

After installing K2 2.3 with the Extension Manager, trying to add an Extra field group I have this error message:TableK2ExtraFieldsGroup::store failed - Table
'Sql12834_4.vl_k2_extra_fields_groups' doesn't exist SQL=INSERT INTO
`vl_k2_extra_fields_groups` ( `id`,`name` ) VALUES ( '','vivigioko' )in the DB any table of K2 was not created!Someone can help me?Giovanni
  • Geoff R
  • Geoff R's Avatar
15 Jun 2010 09:33

HELP Please! Image Gallery not working - Urgent

Category: English K2 Community

Hi, When i try to upload a zip of a few images using K2's item>image gallery (no spaces in names, no folders, just jpgs), I get the error:

UNKNOWNARCHIVETYPE
Gallery upload error: Cannot extract archive!



My K2 settings include:

Web Server
Apache/2.2.15 (Unix) mod_ssl/2.2.15 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_bwlimited/1.4

PHP version
5.2.13

MySQL version
5.0.90-community-log

GD image library
bundled (2.0.34 compatible)

Multibyte string support
Enabled

Upload limit
100M

Memory limit
256M

Open remote files (allow url fopen)
Yes





media/k2/galleries
Writable





Simple Image Gallery Plugin
Installed





Q.  Any ideas how to fix this?

Q.  What is the target folder for uploads, and where is this set in the configuration? What is the permission settings required for this folder?

Thanks...'urgent' help appreciated!

regards,
Geoff
  • Tony Langham
  • Tony Langham's Avatar
12 Jun 2010 16:54
MySQL & none access to my site was created by Tony Langham

MySQL & none access to my site

Category: English K2 Community

Am slowly reading through what you can do / hos to on K2 and tried to do something on my site and after changing something on the Global section a message has come up: Database error. unable to connect to the database: Could not connect to MySQL.

 

As i've not much experience maybe one of you can tell me what to do please.

 
  • william white
  • william white's Avatar
09 Jun 2010 07:24

[Solved]Warning: Invalid argument supplied for foreach() in components/com_k2/views/items/tmpl/default.php

Category: English K2 Community

Do you have your site backed up before the crash?
How many K2 items do you have?
Have you read about the error you are getting - www.databasejournal.com/features/mysql/article.php/3300511/Repairing-Database-Corruption-in-MySQL.htm (scroll down to error)

If you have a large table/tables in k2 with many items, seek expert mysql help before proceeding - especially if you dont have a backup before the errors.
  • PM Muthumbi
  • PM Muthumbi's Avatar
09 Jun 2010 06:52

[Solved]Warning: Invalid argument supplied for foreach() in components/com_k2/views/items/tmpl/default.php

Category: English K2 Community

Someone help me out please,

PM Muthumbi said:Thanks william, Am getting this error in the database. Before i disable, is there a guide into my solution? Error

SQL query: Edit

SHOW FULL FIELDS FROM `jos_k2_items` ;

MySQL said: Documentation
#145 - Table './database/jos_k2_items' is marked as crashed and should be repaired

William White said:Sometimes there are confilcts Try disabling the plugins/componets backwards and testing to see if there is a confilct.
  • kurchania
  • kurchania's Avatar
08 Jun 2010 12:46
Replied by kurchania on topic Attachment bug: SQL error

Attachment bug: SQL error

Category: English K2 Community

Hello my friend ,
Let the K2 Sef Handle everything .in Sh404Sef configuration in By component tab change sh404sef plugin setting of k2 change :-
Use sh404sef plugin if available
to
Use component or core plugin
if you use 2 sh404sef plugin for same k2 than for download header cannot modify.
  • PM Muthumbi
  • PM Muthumbi's Avatar
07 Jun 2010 16:24

[Solved]Warning: Invalid argument supplied for foreach() in components/com_k2/views/items/tmpl/default.php

Category: English K2 Community

Thanks william, Am getting this error in the database. Before i disable, is there a guide into my solution?
Error

SQL query: Edit

SHOW FULL FIELDS FROM `jos_k2_items` ;

MySQL said: Documentation
#145 - Table './database/jos_k2_items' is marked as crashed and should be repaired

William White said:Sometimes there are confilcts Try disabling the plugins/componets backwards and testing to see if there is a confilct.
  • william white
  • william white's Avatar
05 Jun 2010 20:25
Replied by william white on topic Works on Dev, doesn't work on live server

Works on Dev, doesn't work on live server

Category: English K2 Community

That looks like the normal sql statements that are used every time a page gets loaded.
Since your browzer will not report an error, there may be something in the template causing this.
Check all those settings also.
  • Lefteris
  • Lefteris's Avatar
30 May 2010 17:21
Error installing K2 was created by Lefteris

Error installing K2

Category: English K2 Community

Good.
I hope
someone
can help me with this. I'm trying to install the component K2 on my site
and it gives me an error. the same is as follows.Warning:
JInstallerComponent:: require_once (\ hmfsw \ web \ dtcwin008 \
correlavoz.info \ public_html \ administrator \ components \ com_k2 \
install.k2.php) [function.require-once]: failed to open stream: No such
file or directory in \ \ hmfsw \ web \ dtcwin008 \ correlavoz.info \
public_html \ libraries \ joomla \ installer \ adapters \ component.php
on line 291Fatal error: JInstallerComponent:: require_once ()
[function.require]: Failed opening required '\ hmfsw \ web \ dtcwin008 \
correlavoz.info \ public_html \ Administrator \ components \ com_k2 \
install.k2.php' (include_path = '.; E: \ php5 \ ext;
E: \ php5 \ PEAR; E: \ php5 \ PhpCommon ') in \ \ hmfsw \ web \
dtcwin008 \ correlavoz.info \ public_html \ libraries \ joomla \
installer \ adapters \ component.php on line 291Reviewing the
manager after the attempt, I notice that the menu component K2 and the
menu appears on the control panel. In the database
the new tables are created by the installer. In the module
manager does not show any of K2. When I try to import the articles of
joomla, the first item I get an error. In the attached
picture you can see what appears when you try to import the item.I'm
using the followingVersion database: 5.1.41-communityPHP Version:
5.1.2Web Server: Microsoft-IIS/7.5PHP Server
interface: isapiVersion of Joomla Joomla! Stable 1.5.17
[Wojmamni loves woobusani] 27-May-2010 4:00 GMTAnd the php
configuration isRelevant PHP SettingsSetting
ValueSafe Mode (Safe Mode): OffOpening base
directory (Open basedir): NoneDisplay Errors: OnEstiquetas
choices: EnabledUpload: OnMagic quotes
(Magic Quotes): ActivatedGlobal registers (Register Globals):
ActivatedOutput buffer (Output Buffering): OffRoute saved
session (Session Save Path): C: \ WINDOWS \ TempAutomatic Login
(Session Auto Start): 0XML enabled: YesZlib enabled: YesFunctions
disabled: system, shell, exec, system_exec, shell_exec, mysql_pconnect,
passthru, popen, proc_open, proc_close, proc_nice, proc_terminate,
proc_get_status, escapeshellarg, escapeshellcmdMbstring
enabled:
YesIconv Available: YesWYSIWYG Editor: Editor - Editor NoI hope some help
for this excellent component.Thanks
  • Lefteris
  • Lefteris's Avatar
30 May 2010 06:04
Error installing K2 was created by Lefteris

Error installing K2

Category: English K2 Community

Good. I hope someone
can help me with this. I'm trying to install the component K2 on my site
and it gives me an error. the same is as follows.Warning:
JInstallerComponent:: require_once (\ hmfsw \ web \ dtcwin008 \
correlavoz.info \ public_html \ administrator \ components \ com_k2 \
install.k2.php) [function.require-once]: failed to open stream: No such
file or directory in \ \ hmfsw \ web \ dtcwin008 \ correlavoz.info \
public_html \ libraries \ joomla \ installer \ adapters \ component.php
on line 291Fatal error: JInstallerComponent:: require_once ()
[function.require]: Failed opening required '\ hmfsw \ web \ dtcwin008 \
correlavoz.info \ public_html \ Administrator \ components \ com_k2 \
install.k2.php' (include_path = '.; E: \ php5 \ ext;
E: \ php5 \ PEAR; E: \ php5 \ PhpCommon ') in \ \ hmfsw \ web \
dtcwin008 \ correlavoz.info \ public_html \ libraries \ joomla \
installer \ adapters \ component.php on line 291Reviewing the
manager after the attempt, I notice that the menu component K2 and the
menu appears on the control panel. In the database
the new tables are created by the installer. In the module
manager does not show any of K2. When I try to import the articles of
joomla, the first item I get an error. In the attached
picture you can see what appears when you try to import the item.I'm
using the followingVersion database: 5.1.41-communityPHP Version:
5.1.2Web Server: Microsoft-IIS/7.5PHP Server
interface: isapiVersion of Joomla Joomla! Stable 1.5.17
[Wojmamni loves woobusani] 27-May-2010 4:00 GMTAnd the php
configuration isRelevant PHP SettingsSetting
ValueSafe Mode (Safe Mode): OffOpening base
directory (Open basedir): NoneDisplay Errors: OnEstiquetas
choices: EnabledUpload: OnMagic quotes
(Magic Quotes): ActivatedGlobal registers (Register Globals):
ActivatedOutput buffer (Output Buffering): OffRoute saved
session (Session Save Path): C: \ WINDOWS \ TempAutomatic Login
(Session Auto Start): 0XML enabled: YesZlib enabled: YesFunctions
disabled: system, shell, exec, system_exec, shell_exec, mysql_pconnect,
passthru, popen, proc_open, proc_close, proc_nice, proc_terminate,
proc_get_status, escapeshellarg, escapeshellcmdMbstring
enabled: YesIconv Available: YesWYSIWYG Editor: Editor - Editor NoI hope some help
for this excellent component.Thanks
Displaying 681 - 700 out of 793 results.

Powered by Kunena Forum