Keyword

Advanced Search

Search Results (Searched for: Re Error SQL)

  • Fotis
  • Fotis's Avatar
26 May 2020 21:30
Fotis replied the topic:Impossible de supprimer ou dépublier certains commentaires

Impossible de supprimer ou dépublier certains commentaires

Category: Communauté française K2

Perhaps your server is overloaded and the SQL query that is executed to delete these comments never finishes, thus the error.

This is most likely to happen on shared hosting environments.

For now, I would recommend disabling (or protecting) comments. If the spam comments are unpublished, you can just delete them all in one go with "delete all unpublished comments" (top right in the Comments admin page).
  • Plé
  • Plé's Avatar
21 May 2020 17:06
Plé created the topic:Can no longer get into my Joomla site !

Can no longer get into my Joomla site !

Category: English K2 Community

Hi All,
I'm slowly learning how to build a site with Joomla (just on my PC at the moment and I'll transfer it later on OVH to replace my old current B&B site).
I just bought Falang and after activating it, my site worked fine but when I activated all the Falang plugins I suddenly got a blank screen:
"An error has occured.
0 class 'K2Model'not found
Return to control panel"

I cannot return to the control panel! Nothing works! I cannot even log out! I only get this error message.

I've found on the net that I should maybe try this:
Use Phpmyadmin to disable the plugin in the #_extensions table. Change "enabled" 1/0
I have installed XAMPP on my PC and when I click on MySQL Admin I can get to phpMyAdmin but after that I don't know how to get to the #_extensions table ( or K2 for that matter?)

HELP please! I feel desperate. I've spend weeks on creating this new site....
If you have the answer please give me step by step instructions as I'm far from being computer savvy!
Cheers,
Patrick
  • hqbefree
  • hqbefree's Avatar
11 May 2020 00:16
hqbefree replied the topic:Restore K2 Articles

Restore K2 Articles

Category: English K2 Community

Dear Fotis

Thank you so much for your instruction. It all news for me, but I try to learn.
Now I know how to export and import sql database with alot of trouble!

I have created a new database and my current database. I could import the current database now.
There are a lot of K2 tables. I hope I could found every K2 related tables.


I dont want to lost everything again. So I decided to download the backup and the database on my harddisk.

I try with XAMPP first.
I have my full website data on host and a database created.

TROUBLE: I try under the configurate.php

public $list_limit = '20';
public $access = '1';
public $dbtype = 'mysqli';
public $host = 'localhost';
public $user = 'root';
public $password = '';
public $db = 'quangharvest28april2020';
public $dbprefix = 'dfaa_';
public $secret = '';
public $gzip = '1';
public $error_reporting = 'default';
public $helpurl = ' help.joomla.org/proxy?keyref=Help{major}{minor}:{keyref}&lang={langcode }';
public $ftp_host = '127.0.0.1';
public $ftp_port = '21';
public $ftp_enable = '0';
public $tmp_path = 'G:/Alle Programme/xampp/htdocs/quangharvest/default-website/tmp';
public $log_path = 'G:/Alle Programme/xampp/htdocs/quangharvest/default-website/logs';

I GOT THIS WARNING:
Warning: session_start(): Failed to read session data: user (path: G:\Alle Programme\xampp\tmp) in G:\Alle Programme\xampp\htdocs\quangharvest\default-website\libraries\joomla\session\handler\native.php on line 260
Error: Failed to start application: Failed to start the session

I cant do anything more. I search a lot of support on google. But I nothing help.
Please tell me what to do.

I dont set any password on host phpMyAdmin. So I hope the username: root and pw: `"nothingspace" korrect?
  • Fotis
  • Fotis's Avatar
17 Mar 2020 11:51
Fotis replied the topic:K2 404's admin after adding image

K2 404's admin after adding image

Category: English K2 Community

A 500 error means the server is overloaded. Not because of your site but because of other sites on it.

If this happens regularly, you might want to consider changing hosts.

Updating to Joomla latest does not put additional load on the site, let alone when you're using K2 which is lighter in terms of SQL queries compared to Joomla articles. Overall the combo Joomla/K2 is far more performant than many other CMSs. I'm just referencing this in case they slap on the "Joomla is crap at performance, go with WordPress" motto. Which is an epic lie for the record...
  • George Nasis
  • George Nasis's Avatar
05 Mar 2020 20:25
George Nasis created the topic:Error after saving category

Error after saving category

Category: English K2 Community

Hallo,

I face an error after creating or modifying a category.

Is this a bug of 2.10.2?

Error:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 1' at line 1

Thank you
  • Fotis
  • Fotis's Avatar
19 Feb 2020 09:06
Fotis replied the topic:SQL Error while trying to save K2-Category

SQL Error while trying to save K2-Category

Category: English K2 Community

I would say the best one is from JoomReem: www.joomreem.com/extensions-store/jr-maps-for-k2
  • OASE Software GmbH
  • OASE Software GmbH's Avatar
17 Feb 2020 18:11
OASE Software GmbH replied the topic:SQL Error while trying to save K2-Category

SQL Error while trying to save K2-Category

Category: English K2 Community

Fotis wrote: If this is a plugin for easily embedding maps, there are many alternatives out there.

i have searched a while but could not find any map except styleware to show a map of k2 articles with geo locations of a category and all subcategories and jump to article after clicking map-marker.
can you recommend a few to me?
  • Jennie Dawson
  • Jennie Dawson's Avatar
14 Feb 2020 17:02
Jennie Dawson replied the topic:SQL Error while trying to save K2-Category

SQL Error while trying to save K2-Category

Category: English K2 Community

None of the Styleware K2 extensions have been supported since 2016, including swmap. I used to have some of their extensions and have had to phase them out when the developers stopped communicating and bringing out updates. Up to then they were great, apart from SWtabs which was very buggy.

I have recently reported their extensions as abandonware so hopefully they will be taken off the Joomla site soon.
  • Fotis
  • Fotis's Avatar
14 Feb 2020 15:27 - 14 Feb 2020 15:27
Fotis replied the topic:K2 image upload not working with PHP 7.4

K2 image upload not working with PHP 7.4

Category: English K2 Community

Try my suggestions. Enable them all EXCEPT redis, mongodb, newrelic, luasandbox, mysqli (that's correct, you use the newer module already which is mysqlnd), odbc.

If you get a specific conflict error, share it back with us and I'll tell you what to do.
  • Fotis
  • Fotis's Avatar
13 Feb 2020 18:15
Fotis replied the topic:SQL Error while trying to save K2-Category

SQL Error while trying to save K2-Category

Category: English K2 Community

I can only assume the plugin "swmap" is pretty outdated and won't work with the latest version of K2 or possibly your server's PHP if it's been upgraded. If this is a plugin for easily embedding maps, there are many alternatives out there. And even if you don't like one, you can always create a "textarea" type extra field and just embed maps as iframes.
  • OASE Software GmbH
  • OASE Software GmbH's Avatar
12 Feb 2020 13:08
OASE Software GmbH created the topic:SQL Error while trying to save K2-Category

SQL Error while trying to save K2-Category

Category: English K2 Community

dear team!

after i click on save-button while editing existing oder creating new k2-category i get the following error:

Es ist ein Fehler aufgetreten!

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 1' at line 1
JROOT/libraries/joomla/database/driver/mysqli.php:665

Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:665
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
3 JDatabaseDriver->loadResult() JROOT/plugins/k2/swmap/v2.php:121
4 plgK2swmap->prepareItem() JROOT/plugins/k2/swmap/base.php:343
5 SWMapsBase->onAfterK2Save() JROOT/libraries/joomla/event/event.php:70
6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
7 JEventDispatcher->trigger() JROOT/administrator/components/com_k2/models/category.php:138
8 K2ModelCategory->save() JROOT/administrator/components/com_k2/controllers/category.php:27
9 K2ControllerCategory->save() JROOT/administrator/components/com_k2/controllers/category.php:39
10 K2ControllerCategory->apply() JROOT/libraries/src/MVC/Controller/BaseController.php:710
11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_k2/k2.php:147
12 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
13 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
14 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101
15 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159
16 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
17 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51

a little digging resulted that in JROOT/plugins/k2/swmap/v2.php on line 120 where the following code is listed the $item->catid is empty:
$db->setQuery("SELECT alias FROM #__k2_categories WHERE id = {$item->catid} LIMIT 1");

this occures on joomla v3.9.15 with k2 in version 2.10.2, 2.10.1 and 2.10.0 but not on 2.9.0, in this version no error occures?

could you tell me if this bug is allready known and/or when it will be solved?

cheers daniel
  • Fotis
  • Fotis's Avatar
05 Feb 2020 14:32
Fotis replied the topic:Error installing component K2 in joomla 3.9.15

Error installing component K2 in joomla 3.9.15

Category: English K2 Community

The problem is probably related to your MySQL (or MariaDB) configuration. To be exact and as described here dev.mysql.com/doc/refman/5.7/en/innodb-limits.html if "innodb_large_prefix" is set to false, this limit is imposed to databases with utf8mb4_unicode_ci collation.

Your hosting company may have set this option explicitly for backwards compatibility reasons (the default is enabled).

The other option is to download and extract the K2 zip file and edit the file /administrator/components/com_k2/install.mysql.sql replacing all instances of "CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci" with "CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci". Then repackage the contents you extracted into a new zip file and finally install that file in Joomla.
  • zombla
  • zombla's Avatar
05 Feb 2020 13:26 - 05 Feb 2020 13:41
zombla created the topic:Error installing component K2 in joomla 3.9.15

Error installing component K2 in joomla 3.9.15

Category: English K2 Community

Hi there
I cant install K2 extension in my joomla website
Joomla 3.9.15
PHP version 7.3.14
Database Type mysql
Database Version 5.6.47-cll-lve

Error message
Warning
JInstaller: :Install: Error SQL Index column size too large. The maximum column size is 767 bytes.
Extension Install: SQL error processing query: DB function failed with error number 1709
Index column size too large. The maximum column size is 767 bytes.
SQL =

CREATE TABLE IF NOT EXISTS `#__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 `idx_name` (`name`),
KEY `idx_published` (`published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

Error
Error installing component
Any idea ?
Thank you
  • Giuseppe Piffaretti
  • Giuseppe Piffaretti's Avatar
02 Feb 2020 00:34
Giuseppe Piffaretti created the topic:istallazione nuova versione K2 su joomla 3.9....

istallazione nuova versione K2 su joomla 3.9....

Category: Comunità italiana K2

Joomla non installa a causa del seguente errore ( vedi sotto).
Cosa suggerite ?

Grazie
________________________________________________________________

Warning
JInstaller: :Install: Error SQL Index column size too large. The maximum column size is 767 bytes.
Extension Install: SQL error processing query: DB function failed with error number 1709
Index column size too large. The maximum column size is 767 bytes.
SQL =
CREATE TABLE IF NOT EXISTS `#__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 `idx_name` (`name`),
KEY `idx_published` (`published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
×
Error
Error installing component
  • Amine
  • Amine's Avatar
21 Jan 2020 23:15
Amine replied the topic:Error #__k2_items doesn't exist

Error #__k2_items doesn't exist

Category: English K2 Community

Hi ,

I already tried to install the new version, but unfortunately there is an error message ...

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd030e732.qeqo4_k2_items' doesn't exist

It's a fresh joomla installation ...

best regards

Amine
  • Raivis Kapteinis-Miezeris
  • Raivis Kapteinis-Miezeris's Avatar
18 Dec 2019 10:32
Raivis Kapteinis-Miezeris created the topic:Can't upgrade K2 component to latest version

Can't upgrade K2 component to latest version

Category: English K2 Community

Hello!
I have installed Joomla with latest version and K2 v2.9.0. When I try to update K2 to v2.10.2, I receive an error: Unknown character set: 'utf8mb4'.
Default charset of MySQL server ir UTF8, DB default charset is UTF8, also tables default charset is utf8.
What is the problem?
  • Fotis
  • Fotis's Avatar
09 Dec 2019 12:32
Fotis replied the topic:After the update i have this MySQL error.

After the update i have this MySQL error.

Category: English K2 Community

Please let us know if you solve your issues. It may help others as well in the future.
  • Fotis
  • Fotis's Avatar
08 Dec 2019 21:56 - 08 Dec 2019 21:57
Fotis replied the topic:After the update i have this MySQL error.

After the update i have this MySQL error.

Category: English K2 Community

I'm sorry but I can't possibly know what's wrong with your site. You're the first to report such an issue. If it's not a corrupt Joomla/K2 installation, it may be some system plugin causing issues. Start disabling your 3rd party "system" or "k2" type plugins one by one to see which one affects your category save action.
  • Fotis
  • Fotis's Avatar
08 Dec 2019 21:40
Fotis replied the topic:After the update i have this MySQL error.

After the update i have this MySQL error.

Category: English K2 Community

Re-install Joomla from the Joomla Update component and then re-install K2 as well.
  • Max
  • Max's Avatar
08 Dec 2019 20:05
Max replied the topic:After the update i have this MySQL error.

After the update i have this MySQL error.

Category: English K2 Community

I try "maximum reporting" - no more info =(
I get this error when i save the category settings (K2 -> Categories - > "My category" and press [Save & Close]
Displaying 1 - 20 out of 28 results.
Powered by Kunena Forum