Community « Discussion forum « Installation support «
Installation at FREE.FR MySql problem
All query created by yacs give error messages
Hi all
Follow the error on the page http://fabrice.lalande.free.fr/cera/control/populate.php :
SELECT * FROM `fabrice.lalande`.`yacs_users` AS users WHERE (users.id LIKE 'Fabrice') OR (users.nick_name LIKE 'Fabrice') OR (users.email LIKE 'Fabrice') OR (users.handle LIKE 'Fabrice') 1103: Incorrect table name 'yacs_users'
INSERT INTO `fabrice.lalande`.`yacs_users` SET email='fabrice.lalande@free.fr', active='Y', avatar_url='', aim_address='', capability='S', create_name='setup', create_id='0', create_address='', create_date='2006-02-21 15:52:28', description='', edit_name='setup', edit_id='0', edit_address='', edit_action='new', edit_date='2006-02-21 15:52:28', from_where='', full_name='', handle='8473db161176caf58abda91dc0be4d16', icq_address='', interests='', introduction='', irc_address='', jabber_address='', msn_address='', nick_name='Fabrice', options='', password='f313a616403561655ad387450070908f', pgp_key='', post_date='2006-02-21 15:52:28', posts=0, signature='', skype_address='', web_address='', with_newsletters='Y', yahoo_address='' 1103: Incorrect table name 'yacs_users'
SELECT * FROM `fabrice.lalande`.`yacs_users` AS users WHERE (users.id LIKE 'Fabrice') OR (users.nick_name LIKE 'Fabrice') OR (users.email LIKE 'Fabrice') OR (users.handle LIKE 'Fabrice') 1103: Incorrect table name 'yacs_users'
It seems to be the syntax of the query. If I change the :
SELECT * FROM `fabrice.lalande`.`yacs_users`
to :
SELECT * FROM yacs_users It works .....
I am using the latest version of yacs
Some Help
Follow the error on the page http://fabrice.lalande.free.fr/cera/control/populate.php :
SELECT * FROM `fabrice.lalande`.`yacs_users` AS users WHERE (users.id LIKE 'Fabrice') OR (users.nick_name LIKE 'Fabrice') OR (users.email LIKE 'Fabrice') OR (users.handle LIKE 'Fabrice') 1103: Incorrect table name 'yacs_users'
INSERT INTO `fabrice.lalande`.`yacs_users` SET email='fabrice.lalande@free.fr', active='Y', avatar_url='', aim_address='', capability='S', create_name='setup', create_id='0', create_address='', create_date='2006-02-21 15:52:28', description='', edit_name='setup', edit_id='0', edit_address='', edit_action='new', edit_date='2006-02-21 15:52:28', from_where='', full_name='', handle='8473db161176caf58abda91dc0be4d16', icq_address='', interests='', introduction='', irc_address='', jabber_address='', msn_address='', nick_name='Fabrice', options='', password='f313a616403561655ad387450070908f', pgp_key='', post_date='2006-02-21 15:52:28', posts=0, signature='', skype_address='', web_address='', with_newsletters='Y', yahoo_address='' 1103: Incorrect table name 'yacs_users'
SELECT * FROM `fabrice.lalande`.`yacs_users` AS users WHERE (users.id LIKE 'Fabrice') OR (users.nick_name LIKE 'Fabrice') OR (users.email LIKE 'Fabrice') OR (users.handle LIKE 'Fabrice') 1103: Incorrect table name 'yacs_users'
It seems to be the syntax of the query. If I change the :
SELECT * FROM `fabrice.lalande`.`yacs_users`
to :
SELECT * FROM yacs_users It works .....
I am using the latest version of yacs
Some Help
Comments
| Bernard from nearby-an-airport Associate, 6940 posts | Etes-vous sûr que la base de données utilisée pour stocker les tables YACS s'appelle 'fabrice.lalande' ? |
| Fabrice 3 posts |
Bernard : La base de donnée s'appelle bien "fabrice.lalande" j'ai déjà installé d'autre système (galerie photo) sur le site. j'ai regardé les scripts php, ils n'utilisent pas la nom de la Base pour les queries juste le nom de la table. |
| Bernard from nearby-an-airport Associate, 6940 posts |
Fabrice: Ok, un essai simple est de modifier la fonction table_name() dans shared/global.php.Il faut retirer l'usage du nom de la base pour arriver au résultat suivant, à partir de la ligne 317 : Si l'erreur disparait, je reporterai cette modification dans la release 6.2. Merci de me tenir au courant. |
| Fabrice 3 posts | Ok c'est passé la modification marche .... Merci |
| Bernard from nearby-an-airport Associate, 6940 posts |
Fabrice: Adjugé, la nouvelle version de YACS ne fera plus mention du nom de la base de données. Merci de nous avoir fourni les moyens de rendre YACS plus robuste. |
