Main menu

Forum


The developer takes a few days off for Summer vacation...
...and will be back with charged battery!

From 14 June to 29 June, 2025 included
During this period, assistance from developer will not be provided.

NEWS: iCagenda 4.0.0-alpha1 will be available for testing for users with a PRO subscription in July!

  1. General
  3. Announcements
  5. [SQL ERROR] 3.3.0 NEW INSTALL

[SQL ERROR] 3.3.0 NEW INSTALL

  • Lyr!C
  • Lyr!C's Avatar Topic Author
  • Administrator
  • Administrator
  • Lead Developer
More
11 years 3 months ago - 11 years 3 months ago #6691 by Lyr!C
[SQL ERROR] 3.3.0 NEW INSTALL was created by Lyr!C
Hello,

If you have downloaded iCagenda 3.3.0 for the first time in the 3 hours after release of this version, and you have tried a new fresh install of it, you may have faced an error at installation :
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 '{}'')' at line 6 SQL=-- -- Dumping data for table `#__icagenda` -- INSERT INTO `#__icagenda` (id,version,releasedate) VALUES (1,'none','none,'{}'');

Or something like that.

Unfortunately, a few people may have had this error. Please, in this case, download again 3.3.0, and try again!

An error was present in first zip file uploaded, and occures only when a new fresh install of iCagenda.
This error is solved now, and wrong zip has been replaced by the good one!

Thanks to Alessandro A. to have reported me this bug so fast!

And sorry for inconvenience...

Best Regards,
Cyril
Latest version : iCagenda 3.9.11
We recommend every user to keep iCagenda updated.
Don't forget to have your Joomla!™ up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

File Attachment:

Last edit: 11 years 3 months ago by Lyr!C.

Please Log in or Create an account to join the conversation.

  • missycarter
  • New Member
  • New Member
More
10 years 5 months ago #8804 by missycarter
Replied by missycarter on topic [SQL ERROR] 3.3.0 NEW INSTALL
Unknown column 'slug' in 'oua_icagenda_customfields' SQL=ALTER TABLE `oua_icagenda_customfields` ADD `description` VARCHAR(255) NOT NULL AFTER `slug`;

I got the above error after installing the latest version. Please send me an sql query to insert slug column.
Thanks

Please Log in or Create an account to join the conversation.

  • Lyr!C
  • Lyr!C's Avatar Topic Author
  • Administrator
  • Administrator
  • Lead Developer
More
10 years 1 month ago #10169 by Lyr!C
Replied by Lyr!C on topic [SQL ERROR] 3.3.0 NEW INSTALL

missycarter wrote: Unknown column 'slug' in 'oua_icagenda_customfields' SQL=ALTER TABLE `oua_icagenda_customfields` ADD `description` VARCHAR(255) NOT NULL AFTER `slug`;

I got the above error after installing the latest version. Please send me an sql query to insert slug column.
Thanks

Hello,

Sorry, didn't see you message before...

Do you have still this issue ?
Do you have the latest version, as this issue is now fixed, and was an error in sql update files, not well managed by Joomla SQL updater.

Regards,
Cyril
Latest version : iCagenda 3.9.11
We recommend every user to keep iCagenda updated.
Don't forget to have your Joomla!™ up-to-date!

Do you like iCagenda?
I would appreciate if you could take 5 minutes to post a review on JED (Joomla Extensions Directory) .

File Attachment:

Please Log in or Create an account to join the conversation.

Moderators: Lyr!C
  1. General
  3. Announcements
  5. [SQL ERROR] 3.3.0 NEW INSTALL
Time to create page: 0.137 seconds

Legal

Follow Us

Create your Joomla templates with Template Creator CK

acymailing logo new

Simplify Your Web