Login
Register

VirtueMart

WooCommerce

Others

Docs

Support

Blog

About

Shipping by Rules for VirtueMart

IMPORTANT ANNOUNCEMENT: Plugin development ceased, all plugins made available freely (GPL)

With great sadness we have to announce that we are ceasing development of all our VirtueMart, WooCommerce and Joomla plugins. Effective immediately, all our plugins -- even those that were paid downloads -- are made available for free from our homepage (GPL license still applies), but we cannot and will not provide any support anymore.

It has been a great pleasure to be part of the thriving development communities of VirtueMart as well as WooCommerce. However, during the last year it became painstakingly clear that in addition to a full-time job, a young family and several other time-consuming hobbies at professional level (like being a professional singer) the plugin development and the support that it requires is not sustainable and is taking its toll. It has been an honor, but it is now time to say good bye!

×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

Error: 1059 Identifier name is too long 05 May 2015 10:23 #1

  • Olajo
  • Olajo's Avatar Topic Author
Hi!
When I try to add advanced shipping by rules I get the Error: 1059 Identifiername is too long. SQL=CREATE TABLE IF NOT EXISTS
Is a way to get around this problem or how do I add the Table in MYSQL database. I´m not very good in editing databases.
Happy if you could help me.
/Regards

Error: 1059 Identifier name is too long 11 May 2015 21:16 #2

Dear Olajo,
That is quite a strange error message. Is this the whole error message, or does it continue on a second line? If so, the actual table name it tries to create would be the vital information (maybe you can even make a screenshot).

You should not have to do anything in the mysql database yourself, Virtuemart should automatically create the correct database table for each plugin...

Additional information that could be relevant:
PHP version?
mysql version?
Joomla version?
VirtueMart version?

Best regards,
Reinhold

Error: 1059 Identifier name is too long 12 May 2015 09:08 #3

  • Olajo
  • Olajo's Avatar Topic Author
Hi Renold!
This is the full error-message I receive when trying to save a new rule in Virtuemart.
See added image

Joomla 3.4.1.
Virtuemart 3.0.8
PHP 5.5.20

Best regards
Attachments:

Error: 1059 Identifier name is too long 14 May 2015 14:31 #4

Dear Olajo,
Thank you for your screenshot. Apparently, you have a very long database table prefix chosen for your joomla installation. VirtueMart uses database tables with a fixed naming structure:
{prefix}_{plugintype}_plg_{pluginname}

Due to your long prefix, that table name generated by core VirtueMart is longer than 64 characters, which is the limit for MySQL database tables: dev.mysql.com/doc/refman/5.0/en/identifiers.html

I don't think there is anything we can do, except for you choosing a shorter table prefix. I suppose that you might run into problems with other plugins, too, if their table names are longer than ca. 35 characters.
Usually, the table prefix for joomla should not be longer than 3 or 4 characters...

Best regards,
Reinhold
  • Page:
  • 1