Keyword

Advanced Search

Search Results (Searched for: Re Error SQL)

  • 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
  • Just Organize Your Stuff JOYS
  • Just Organize Your Stuff JOYS's Avatar
14 May 2010 18:47
FYI TableK2Item::store failed - Incorrect key file for table was created by Just Organize Your Stuff JOYS

FYI TableK2Item::store failed - Incorrect key file for table

Category: English K2 Community

I got this error

TableK2Item::store failed - Incorrect key file for table



I found this on the joomla site.

I reported it to my hosting provider and they told me that it was an error in their global mysql service and
they had to fix it.

Else I had to repair the jos_session table from MyPhPAdmin:
1) Enter your Hosting Cpanel
2) Select PhpMyAdmin
3) Select your data base
4) Check the table jos_session
5) At the bottom search for a drop list and select the option: repair
the table
That worked for me.



My host helped me fix it and said that is was caused by a lot of adding and deleting.

Concerned me because, that is what we do add content. It will probably happen again



He gave me this link when I asked if there was a way I could fix it automatically...



www.mydigitallife.info/2007/09/21/check-and-optimize-mysql-database-automatically-with-crontabcron/



Just incase anyone else runs into similar problems.
  • Sarah cnr
  • Sarah cnr's Avatar
13 Apr 2010 21:03
Extra fields was created by Sarah cnr

Extra fields

Category: English K2 Community

Hello,please anyone be so kind to help me... i have a really bad day because of this error message:/Im using joomla 1.5.15 and k2 v2.2after i add any extra field to any category i receive such a message (see attached)..please, any suggestions?p.s. im using rockettheme affinity template (everything else works fine).please please please...DB function failed with error number 1064You have
an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'AND published=1
AND trash=0 AND access<=1' at line 1 SQL=SELECT * FROM
jos_k2_categories WHERE id= AND published=1 AND trash=0 AND access<=1




Warning: Invalid argument supplied for foreach() in /home/a3930998/public_html/components/com_k2/sef_ext/com_k2.php on line 98this one allso don't workhttp://www.joomvision.com/Blog/How-to-solve-the-K2-Database-error-DB-function-failed-with-error-number-1064.htmlim getting a new "warning on line"
  • Sarah cnr
  • Sarah cnr's Avatar
09 Apr 2010 14:53
1064 was created by Sarah cnr

1064

Category: English K2 Community

Hello,im using k2v2 joomla 1.5.15 and i have some problems with extra fields...when i try to assign any of them to some category i get an error:DB function failed with error number 1064You have
an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'AND published=1
AND trash=0 AND access<=1' at line 1 SQL=SELECT * FROM
jos_k2_categories WHERE id= AND published=1 AND trash=0 AND access<=1
PHP Error Message



Warning: Invalid argument supplied for foreach() in /home/a3930998/public_html/components/com_k2/sef_ext/com_k2.php
on line 98
but anyway extra fields adds sucessfully. Where could be the problem?this one doesn't work:http://www.joomvision.com/Blog/How-to-solve-the-K2-Database-error-DB-function-failed-with-error-number-1064.htmlplz help someone... maybe there are some additional settings i need to change in extra fields?
  • PM Muthumbi
  • PM Muthumbi's Avatar
13 Mar 2010 06:47
Replied by PM Muthumbi on topic Attachment bug: SQL error

Attachment bug: SQL error

Category: English K2 Community

This refuses to work for me, am i missing out something? I have followed the steps but still i get Invalid argument supplied for foreach() in \components\com_k2\views\latest\view.html.php on line 120. Any help please i am really having a headache on this.

tonino said:Hello my friend, I resolved in this way (I am no expert in php): i have edit / components/com_k2/templates/default/item.php look for the line of code n 354

I attach a file in text format because it is impossible to paste code on this forum

To me it worked!

Sorry for my English
Displaying 681 - 700 out of 789 results.

Powered by Kunena Forum