SQL=SELECT id AS value, name AS joobase FROM b2b_

More
10 years 3 months ago #2705 by richardchagonda
SQL=SELECT id AS value, name AS joobase FROM b2b_ was created by richardchagonda
i downloaded and installed smooth but now when i try to configure the module in the back end, i get this error: SQL=SELECT id AS value, name AS joobase FROM b2b_joodb

Can anyone help.

Attachment hbf11969.jpg not found

This message has an attachment image.
Please log in or register to see it.

Please Log in to join the conversation.

More
10 years 3 months ago #2707 by Dirk
Replied by Dirk on topic SQL=SELECT id AS value, name AS joobase FROM b2b_
As stupid question: "have you installed the joodb component?"

If YES provide us with more information. E.g. Joodb and Joomla version.

btw.: The module only works with the pro version.

Please Log in to join the conversation.

More
9 years 1 month ago #3262 by treenet
Replied by treenet on topic SQL=SELECT id AS value, name AS joobase FROM b2b_
{joodb orderlink|Jméno|Jméno} dont work. The character generate error 1054 - Unknown column 'a.Jmno' in 'order clause' SQL=SELECT a.* FROM `Kontakty` AS a GROUP BY a.`ID` ORDER BY a.`Jmno` ASC LIMIT 0, 25

Tomas on againstwar.eu

Please Log in to join the conversation.

More
9 years 1 month ago #3265 by Dirk
Replied by Dirk on topic SQL=SELECT id AS value, name AS joobase FROM b2b_
See here
dev.mysql.com/doc/refman/5.0/en/identifiers.html

Dont use accents or umlauts for collumn names.

Please Log in to join the conversation.

Moderators: Dirk, joest