Keyword

Advanced Search

Search Results (Searched for: Re Error SQL)

  • Karen Liebman
  • Karen Liebman's Avatar
18 Oct 2011 17:06
Can't Create Slides or Categories was created by Karen Liebman

Can't Create Slides or Categories

Category: Frontpage Slideshow

Hello,

Yesterday I upgraded from version 2.9.4 to 3.0.2 and encountered several problems.

All my old slides disappeared, which is fine, but when I tried to re-upload them, I got an error message:
FPSSSLIDE::store failed - Unknown column 'title' in 'field list' SQL=INSERT INTO' sgj_fpss_slides' ( 'is', 'title', 'published', 'publish_up;, 'publish_down', 'created', 'created_by', 'access', 'ordering', 'featured;, 'featured_ordering', 'text', 'tagline', referenceType', 'referenceID', 'hits', 'params') VALUES ('0', 'Events', '1', '1', '2011-10-17 16:06:00', '0000-00-00 00:00:00', '2011-10-17 16:07:55', '04', '1', '0', '', '', Tagline', 'com_menus', '5', '0', 'useOriginal-\ntitle-\ntext-\ntagline-\ncategory-\nauthor-\nreadmore-\ntarget-\nliveData-\n\n' )

I tried to create/edit categories and got a similar error message (see second screen shot).
FPSSCategory::store failed - Unknown column 'params' in 'field list' SQL-UPDATE 'sgj_fpss_categories' SET 'name' = 'Homepage', 'published'='1', 'params'='imageWidth=350\nimageQuality=100\nthumbWidth=100\nthumbQuality=75\npreviewWidth="900\npreviewQuality=90\ntitle=0\ntext=0\ntagline=0\ncategory=0\ncategory=0\nauthor=0\nreadmore=0\ntarget WHERE id='2'

I'm sure I'm just doing something embarrassingly simple wrong, but I could really use the help!  Thanks.
  • Trentin C Bergeron
  • Trentin C Bergeron's Avatar
11 Oct 2011 07:44

Backend - Edit or New Article - Content Image Field Area Not Visible

Category: English K2 Community

When I create a new article or edit an existing article, the content input area is missing.  So is the image area. You can select the tabs, but nothing appears below. I cannot add content or images. I cannot see the current content or images. Content is showing up on the front end. I have tried installing the System - SC jQuery and enabled Mootools upgrade and that didn't help.



Site:  www.10nw-web.com

 

K2 Settings:


Web Server


Apache/1.3.42 (Unix) mod_gzip/1.3.26.1a mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.8e-fips-rhel5 PHP-CGI/0.9



PHP version


5.2.17



MySQL version


5.0.91mm-log



GD image library


bundled (2.0.34 compatible)



Multibyte string support


Enabled



Upload limit


24M



Memory limit


96M



Open remote files (allow url fopen)


Yes






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






mod_k2_comments


 



mod_k2_content


Installed



mod_k2_login


Installed



mod_k2_tools


Installed



mod_k2_users


Installed



mod_k2_quickicons (administrator)


Installed






System - K2


Installed - Enabled



User - K2


Installed - Enabled



Search - K2


Installed - Enabled





 

System Information


Setting


Value




 



PHP Built on:


Linux serv01.siteground155.com 2.6.38.6-sg4-nomm-nogrsec #1 SMP Wed May 18 08:51:09 CDT 2011 i686



Database Version:


5.0.91mm-log



Database Collation:


utf8_general_ci



PHP Version:


5.2.17



Web Server:


Apache/1.3.42 (Unix) mod_gzip/1.3.26.1a mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.8e-fips-rhel5 PHP-CGI/0.9



Web Server to PHP interface:


cgi



Joomla! Version:


Joomla! 1.5.22 Stable [ senu takaa ama woi ] 04-November-2010 18:00 GMT



User Agent:


Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1





 

Relevant PHP Settings


Setting


Value




 



Safe Mode:


Off



Open basedir:


None



Display Errors:


On



Short Open Tags:


On



File Uploads:


On



Magic Quotes:


On



Register Globals:


Off



Output Buffering:


Off



Session Save Path:


/tmp



Session Auto Start:


0



XML Enabled:


Yes



Zlib Enabled:


Yes



Disabled Functions:


None



Mbstring Enabled:


Yes



Iconv Available:


Yes



WYSIWYG Editor:


Editor - No Edito





 
  • Pixel Point Creative LLC
  • Pixel Point Creative LLC's Avatar
30 Sep 2011 16:20
Replied by Pixel Point Creative LLC on topic Where and when I can download K2 for Joomla 1.7?

Where and when I can download K2 for Joomla 1.7?

Category: English K2 Community

I wanted to share my experiences with everyone. I have been following this thread for a while now and like everyone else here really do love K2 and hope for a release soon. That being said, I had a 1.5 site that used K2 and the client really wanted to upgrade to 1.7. I decided to give it a go with the K2 2.5 SVN. All said and done it now functions and works well minus one issue I didn't look into fixing. That is item ordering does not work int he admin. Other than that I was able to get everything else working OK, BUT it was a huge headache and took some skills. If you don't have some My SQL and Php My admin skills, you might as well forget it. My approach was to export the tables from the 1.5 version and import them into the 1.7 version. First problem upon inspection is that the permissions were not copied. This made it so you could not browse to any K2 item in the front end without a 404. I had to bulk update the permissions column in the database for all items and categories. Now I could see the items in the frontend. Next, i wasn't able to save anything in K2. No category or item changes. The error I received was about a missing language column. Again I bulk updated the items and categories tables. I added a language column. This solved it. Next, all images were lost. Had to redo them. Not practical for a big site. In my case it was only about 30-40. Attachments did not work either. They were in the proper folder media/k2/attachments. The association to the files was not working. 404 page. I eventually found a post in this forum to direct link to attachments. That worked and I was back in business. Finally the settings for categories (ie comments off, hits on) appeared to be copied over when viewing in the front end, but if you decided to edit and item or category, they were all lost and reverted back to default. So I had to redo the setting for the categories. Not too bad since most inherited theirs from one or two categories. All in all it was a learning experience. As of now, I have a fully functional 1.7 site running K2 2.5 SVN, but it WAS a hassle and not practical for most. I am hoping that K2 releases a migration tool when the stable version is out to avoid all the pitfalls i have had. My two cents. If you really want to migrate your site now, it will be a pain and you will not be happy while you are doing it. Once it is done, it works but still a huge hassle. I would also suggest cloning your site and doing on a dev server so you can work through it over time. All and all the SVN seems pretty stable once it was all running. I think installed it on a new 1.7 site would be OK. Hopefully they will iron out the remaining bugs and get a item migrator in place and we might be in business.........................hopefully before Joomla 3.5 is released. :)
  • darthphunk
  • darthphunk's Avatar
23 Sep 2011 00:29
Error when creating a category? was created by darthphunk

Error when creating a category?

Category: Frontpage Slideshow

Need help guys.

I have Joomla 1.5 and was running FPSS 2.9.4 and the read more button looked weird.  I figured it must not like my site template.  Rather than troublelshoot it, I decided to upgrade to 3.0.2 and see if the problem was still there.

I have a different problem now.

I deleted the "Demo" category so I could add my own categories. I successfully deleted the demo category and when I tried to add my own, I get the following message:

FPSSCategory::store failed - Unknown column 'ordering' in 'field list' SQL=INSERT INTO `jos_fpss_categories` ( `id`,`name`,`published`,`ordering`,`params` ) VALUES ( '0','TEST','1','','imageWidth=500\nimageQuality=90\nthumbWidth=100\nthumbQuality=75\npreviewWidth=900\npreviewQuality=90\ntitle=1\ntext=1\ntagline=1\ncategory=1\nauthor=1\nreadmore=1\ntarget=_self\nliveData=1\n\n' )


Can anyone help?
  • Scott Ackerman
  • Scott Ackerman's Avatar
21 Sep 2011 19:21
Error building admin menus was created by Scott Ackerman

Error building admin menus

Category: English K2 Community

I have read in other forum posts that this is 'only' due to a Joomla 1.7 site that has been upgraded to 1.6 that is using Front Page Slideshow. Untrue! I have a fresh Joomla 1.7 install and am not using Front Page Slideshow and am not able to use K2 because of the error. I have the following extensions installed:

Akeebabackup 3.3.4Admin Tools 2.1.6Contact Enhanced 1.6.3Gantry 3.2.11JCE 2.0.14NoNumber Extension Manager with Advanced Module Manager, Articles Anywhere and Cache Cleaner installedVersions 1.851 by Fatica Consulting

 

PHP 2.6.32MySQL 5.1.52

I supposed I could start with a fresh install of 1.7 and iteratively add extensions and see when K2 won't install but I don't have any problem installing any other extensions so it certainly 'sounds' like a K2 installation issue.
  • Andreas Schoeneberg
  • Andreas Schoeneberg's Avatar
20 Sep 2011 14:58
Replied by Andreas Schoeneberg on topic [Solved] Can't build categories

[Solved] Can't build categories

Category: Frontpage Slideshow

Thanks for your quick replay. I tried to install version 3, but I get an error message:

JInstaller::install: SQL-Fehler DB function failed with error number 1064
Fehler in der Syntax bei 'DEFAULT CHARSET=utf8' in Zeile 12. SQL=CREATE TABLE IF NOT EXISTS `jos_fpss_categories` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `published` tinyint(1) unsigned NOT NULL, `ordering` int(11) NOT NULL, `language` char(7) NOT NULL, `params` text NOT NULL, PRIMARY KEY (`id`), KEY `published` (`published`), KEY `ordering` (`ordering`), KEY `language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_fpss_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `published` tinyint(1) unsigned NOT NULL,
  `ordering` int(11) NOT NULL,
  `language` char(7) NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `published` (`published`),
  KEY `ordering` (`ordering`),
  KEY `language` (`language`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
  • Wesley Daniels
  • Wesley Daniels 's Avatar
15 Sep 2011 00:52
Replied by Wesley Daniels on topic FPSS Won't Let Me Add Any Slides :'( Need Help Please!

FPSS Won't Let Me Add Any Slides :'( Need Help Please!

Category: Frontpage Slideshow

Hi. A blank page indicates a PHP error. Set error reporting to maximum through Joomla! configuration in order to see what's the error. Also make sure that your server meets the requirements for running the Frontpage Slideshow.


Hi mate. How do i set error reporting to maximum? Also I read something about possibly needing to upgrade mySQL to solve this problem. How would I do this?

forum.joomlaworks.net/frontpage-slideshow-v1-v2-(for-joomla!)/(solved)-can-not-configure-new-slides-blank-page/?PHPSESSID=3549a9a38899df8bf52db39ccc81167c

Thanks in advance.

Wesley
  • Matthew Bibby
  • Matthew Bibby's Avatar
11 Sep 2011 08:33
Unable to change the basic menu options for K2 was created by Matthew Bibby

Unable to change the basic menu options for K2

Category: English K2 Community

Hi,

 

I am new to K2 and Joomla, so this may be a user error or perhaps a bug in the SVN.

 

When creating a K2 Categories Menu Item, I am unable to change the options shown in the attached image.  Clicking the dropdown boxes does nothing and I am not able to type in the text fields.

 

Any ideas on what could be causing this?

 

Thanks,

 

Matt

 

Joomla! version: 1.7 | K2 v2.5 (SVN) | PHP version: 5.2.6-1 lenny10 | MySQL version: 5.0.51a | Webserver version: Apache/2.2.9 (Debian) mod_jk/1.2.26 PHP/5.2.6-1 lenny10 with Suhosin-Patch mod_python/3.3.1 Python/2.5.2 mod_ssl/2.2.9 OpenSSL/0.9.8g mod_perl/2.0.4 Perl/v5.10.0 | Joomla! template used: Panacea v1.6.2 (RocketTheme) 

 
  • that library
  • that library's Avatar
08 Sep 2011 18:21

k2_categories table has no language field in db - Joomla 1.6 with K2 SVN 2.5(RC)

Category: English K2 Community

I finally got upgraded (via Jupgrade) from Joomla v1.5.23 to 1.6.6, and installed the K2 SVN 2.5(RC) on the 1.6 site, which, thankfully is now acknowledged by J1.6 within the menu manager. This is a start but I'm having a strange issue that I hope someone can help me with:

 

I want to stress that the K2 content is in the j16_ database tables where it should be, I can see & access it within the admin area of the 1.6 site, but it's just not showing up on the front end at all. I think the major reason for this is because:


Each category's access column in the database j16_k2_categories is set to 0 instead of 1, when I try to change this for the parent category, I get a big db error, because:
There is no column for language, so when I try to change anything in the parent category (from which all others inherit their parameters (or any category), I get the following error:

TableK2Category: :store failedUnknown column 'language' in 'field list' SQL=UPDATE `j16_k2_categories` SET `name`='Library',`alias`='library-main',`description`=' **description went here**

',`parent`='0',`extraFieldsGroup`='1',`published`='1',`access`='1',`params`='{\"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\",\"feedLink\":\"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\":\"\",\"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\",\"itemTwitterLink\":\"1\",\"itemCategory\":\"1\",\"itemTags\":\"1\",\"itemShareLinks\":\"1\",\"itemAttachments\":\"1\",\"itemAttachmentsCounter\":\"1\",\"itemRelated\":\"1\",\"itemRelatedLimit\":\"5\",\"itemVideo\":\"1\",\"itemVideoWidth\":\"\",\"itemVideoHeight\":\"\",\"itemVideoAutoPlay\":\"0\",\"itemVideoCaption\":\"1\",\"itemVideoCredits\":\"1\",\"itemImageGallery\":\"1\",\"itemNavigation\":\"1\",\"itemComments\":\"1\",\"itemAuthorBlock\":\"1\",\"itemAuthorImage\":\"1\",\"itemAuthorDescription\":\"1\",\"itemAuthorURL\":\"1\",\"itemAuthorEmail\":\"0\",\"itemAuthorLatest\":\"1\",\"itemAuthorLatestLimit\":\"5\",\"itemK2Plugins\":\"1\"}',`language`='en-GB' WHERE id='23'


Even with the seo-friendly links turned on, J1.6 has /en/ within the links, so the language field in the k2_categories has to exist.

 

So clearly I need to add another field to not only the K2 categories, but where would it go? What I mean is where should I insert this field within that db table (in between something, at the end)? And would the items be able to be seen (retrieved properly) if it is only in the categories table after that?

Or do I need to execute a SQL query to insert it into the k2_items table as well?

 

It is worth noting that I do have a number of languages installed, but even before I installed them, all Joomla! categories & content are automatically listed as "Language - All." 

 

Can someone please help me out with this?

Bueller? Bueller?
  • warszcz
  • warszcz's Avatar
29 Aug 2011 16:26
import execution timout was created by warszcz

import execution timout

Category: English K2 Community

Hi,

during old joomla content import I received following error:

Fatal error: Maximum execution time of 30 seconds exceeded in /.../public_html/libraries/joomla/utilities/arrayhelper.php on line 163

I have some content to import (more or less 1000 articules, no images at all, largest category contain 4000 articles).

My ecosystem is: Joomla 1.5.23 (updated from initial 1.5.15)  / PHP 5.2.14 / Mysql 5.0.90-community.

Even I tried to archive part of old Joomla content; then import; then unarchive and archieve another part import and so on. But in Joomla! you can only archieve articules not categories, and it seems that even importing categories without any article takes a lot of time.

What advice? Any dimensioning? Any trick?

BTW:

Of course I have no access to php.ini to upper max_execution_time.- this is standard hosting not XAMP instalation.

BTW2: I am novice to K2 so I post it here, may be this is not a proper place - if so: please redirect the topic.

 

Best regards & Thanx in advance!
  • Tim Senft
  • Tim Senft's Avatar
28 Aug 2011 21:04

Error causing site to be sluggish and crash - public_html/components/com_k2/sef_ext/com_k2.php on line 98

Category: English K2 Community

Our site has been running slow since yesterday and is crashing often. We received this error once when navigating the site: DB function failed with error number 2006 MySQL server has gone away SQL=SELECT * FROM jos_k2_categories WHERE id=6 AND published=1 AND trash=0 AND access<=0 Warning: Invalid argument supplied for foreach() in /home/***/public_html/components/com_k2/sef_ext/com_k2.php on line 115 DB function failed with error number 2006 MySQL server has gone away SQL=SELECT * FROM jos_k2_categories WHERE id= AND published=1 AND trash=0 AND access<=0 Warning: Invalid argument supplied for foreach() in /home/****/public_html/components/com_k2/sef_ext/com_k2.php on line 98 DB function failed with error number 2006 MySQL server has gone away SQL=SELECT name, link,id FROM jos_menu WHERE id = 77 AND published='1' I forwarded the error message to our hosting provider and this was his reply: Thank you for contacting Hostgator.com. Mysql appears to be running fine ( if it was offline your site would not display) what seems to be the problem is with the joomla plugin com_k2 on this line of its code. /home/****/public_html/components/com_k2/sef_ext/com_k2.php 98 foreach ($fullPath as $path) { 115 foreach ($fullPath as $path) {' I was unable to login to your admin to test this plugin, you may want to check with the creator of the plugin. do you know what would be the cause of this problem and how to fix it? Thanks,
  • hans zuidinga
  • hans zuidinga's Avatar
23 Aug 2011 13:36 - 23 Aug 2011 13:40
Upgrade to version 3 doesn't work was created by hans zuidinga

Upgrade to version 3 doesn't work

Category: Frontpage Slideshow

a very good to you all,

we installed the upgrade (backup, uninstall version 2, install version 3).
verson worked fine.

www.fotolooman.nl

verson 3 gives these error messages:

Warning: Invalid argument supplied for foreach() in /www/htdocs/fotoloom/templates/theme018/html/mod_fpss/Movies/default.php on line 21

    «

    Warning: Invalid argument supplied for foreach() in /www/htdocs/fotoloom/templates/theme018/html/mod_fpss/Movies/default.php on line 70
    »
    Pause

This info is under the information tab:

Web server: Apache/2.2.17 (Unix) DAV/2 mod_ssl/2.2.17 OpenSSL/1.0.0d FrontPage/5.0.2.2635
PHP version: 5.2.17
MySQL version: 5.0.77
GD Image library: bundled (2.0.34 compatible)
Upload limit: 16M
Memory limit: 32M

is this a server issue or an install issue?

thanks in advance.
  • Edgar Javier Montero C.
  • Edgar Javier Montero C.'s Avatar
17 Aug 2011 20:20
1.6.x to 1.7 upgrade was created by Edgar Javier Montero C.

1.6.x to 1.7 upgrade

Category: Frontpage Slideshow

I have an installation of jommla I upgraded from 1.6.4 to version 1.7 currently I also I have to upgrade components and modules in this update my frontpage slideshow and I have the following error messages.

Warning: Invalid argument supplied for foreach() in /home/content/90/7666090/html/deporpana/libraries/joomla/database/database/mysql.php on line 368

my site is in Spanish not know if that has anything to do with the errors:

Warning: Invalid argument supplied for foreach() in /home/content/90/7666090/html/deporpana/administrator/components/com_fpss/views/slides/view.html.php on line 51

Warning: array_unshift() [function.array-unshift]: The first argument should be an array in /home/content/90/7666090/html/deporpana/administrator/components/com_fpss/helpers/html.php on line 39

Warning: Invalid argument supplied for foreach() in /home/content/90/7666090/html/deporpana/libraries/joomla/html/html/select.php on line 518

Warning: Invalid argument supplied for foreach() in /home/content/90/7666090/html/deporpana/administrator/components/com_fpss/views/slides/tmpl/default.php on line 61

Tengo una instalacion de jommla que he actualizado desde la 1.6.4 hasta actualmente la version 1.7 he igualmente tengo que actualizar los componentes y modulos, en este actualizo mi frontpage slideshow y tengo esos mensajes de error:

No se si afecta que mi web esta en español. y nunca utilizo el fihs
my site is in Spanish not know if that has anything to do with the errors
  • stavroch
  • stavroch's Avatar
11 Aug 2011 14:39

jos_jxfinder_links_terms3' is marked as crashed

Category: English K2 Community

Ι try to delete one category and I get the following error.

 

Table './XXXX/jos_jxfinder_links_terms3' is marked as crashed and should be repaired SQL=UPDATE `jos_jxfinder_terms` AS t INNER JOIN `jos_jxfinder_links_terms3` AS m ON m.term_id = t.term_id SET t.links = t.links - 1 WHERE m.link_id = 543

 

Do I have to run "REPAIR TABLE jos_k2_items" from MySQL as Joe posted on the community.getk2.org/forum/topics/invalid-arguement

 

Thank u.
  • Jerin Mehedi
  • Jerin Mehedi's Avatar
11 Jul 2011 14:31
Replied by Jerin Mehedi on topic Error create categories

Error create categories

Category: English K2 Community

sorry to interfare but my k2 link information say "


 

Web Server


Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635

PHP version
5.2.17

MySQL version
5.0.92-community

GD image library
bundled (2.0.34 compatible)

Multibyte string support
Enabled

Upload limit
2M

Memory limit
50M

Open remote files (allow url fopen)
Yes

 

 

 

 

 

 

 

 

 






But Still i cant create any categories and shows problem "" Fatal error: Call to undefined function mb_regex_encoding() in /home/blogalap/public_html/test/administrator/components/com_k2/tables/k2category.php on line 88 "
  • B_Dark
  • B_Dark's Avatar
31 May 2011 22:12

Is it possible to mass add a tag in all items of one category?!

Category: English K2 Community

  and I  started  thinking that is for php because I had never seen such a code for sql again :P

Andrea Vigato said:
hmm, what are you using to do the code? what file?

 

MySQL said: 
#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 '$db =& JFactory::getDBO()' at line 1

 

the $db line is not into the query, so how it's possible mysql said that?

 

are you using the code from phpmyadmin maybe?

 

What i wrote down is to use in a php file, just load the file and then it will start the queries directly from PHP. 

You cannot do it from something else because you need to save variables and cycle.

 

If you want you can pass me the DB and i will do it for you directly now, i'm actually in free time :) or, you have to copy the code in a php file (also the index.php) and just load it. After that remove the code.

 
  • Andrea Vigato
  • Andrea Vigato's Avatar
31 May 2011 22:08

Is it possible to mass add a tag in all items of one category?!

Category: English K2 Community

hmm, what are you using to do the code? what file?

 

MySQL said: 
#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 '$db =& JFactory::getDBO()' at line 1

 

the $db line is not into the query, so how it's possible mysql said that?

 

are you using the code from phpmyadmin maybe?

 

What i wrote down is to use in a php file, just load the file and then it will start the queries directly from PHP. 

You cannot do it from something else because you need to save variables and cycle.

 

If you want you can pass me the DB and i will do it for you directly now, i'm actually in free time :) or, you have to copy the code in a php file (also the index.php) and just load it. After that remove the code.

 
  • B_Dark
  • B_Dark's Avatar
31 May 2011 21:37

Is it possible to mass add a tag in all items of one category?!

Category: English K2 Community

Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 5 STR: =& SQL: $db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();$db =& JFactory::getDBO();

SQL query:

$db =& JFactory::getDBO();

MySQL said:
#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 '$db =& JFactory::getDBO()' at line 1


B_Dark said:
$db =& JFactory::getDBO(); $first_query = "SELECT ID FROM jos_k2_items WHERE catid=8"; $db->setQuery($first_query);$counter = $db->getNumRows(); $column= $db->loadResultArray(); $start_id = 44;for($i=0; $i<=$counter; $i++) {$second_query = "INSERT INTO jos_k2_tags_xref VALUES ($start_id, 40, $column[$i])"; $db->setQuery($second_query); $start_id++;}right?
  • B_Dark
  • B_Dark's Avatar
31 May 2011 19:36

Is it possible to mass add a tag in all items of one category?!

Category: English K2 Community

the right sec teble name is jos_k2_tags_xref#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 'INSERT INTO jos_k2_tags_xref VALUES (44, 40, itemID) LIMIT 0, 30' at line 6
SELECT IDFROM jos_k2_itemsWHERE catid =33INSERT INTO jos_k2_tags_xrefVALUES ( [/code]44, 40, itemID ) LIMIT 0 , 30they give me this message, what i write wrong?[/code]
  • Stark Robert
  • Stark Robert's Avatar
24 May 2011 05:56
Error $text was created by Stark Robert

Error $text

Category: Simple Image Gallery PRO

Hi,

I continually get this error:

Undefined property: stdClass::$text in plugins\content\jw_sigpro.php

I am using UniServer 7.0.0 Orion:
Apache 2.2.17
MySQL 5.5.10
PHP 5.3.6 -

I am worried as this extension is used extensively throughout my sites - and rochenhost has announced the phasing out of php 5.2 at the end of this month and a lot of Joomla sites are hosted there: my.rochen.com/publicAnnouncements.php?ann_id=64

Is there a fix?
Displaying 621 - 640 out of 793 results.

Powered by Kunena Forum