pragmaMx Support Forum

pragmaMx => Installation & Update => Thema gestartet von: richard2 am 23 Januar 2004, 07:39:11

Titel: Messenger sql
Beitrag von: richard2 am 23 Januar 2004, 07:39:11
Hi, bekomm ne Fehlermeldung bei klick auch vkp2 messenger.

Error sql_query():
qry: SELECT DISTINCTROW a.aid, u.uname FROM mx_users AS u LEFT JOIN mx_authors AS a ON u.uid = a.user_uid WHERE (((u.uname) Not In (""Nicht angemeldet"") And (u.uname) Is Not Null) AND (u.user_stat=1) AND (u.user_lastvisit >= 1074839055) AND (u.user_lastmod<>'logout'));
descr: 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 'Nicht angemeldet"") And (u.uname) Is Not Null) AND (u.u ( mysql 1064 )

Error sql_fetch_row():
descr: mysql_fetch_row(): supplied argument is not a valid MySQL result resource


Hat jemand nen Plan?
Titel: Re: Messenger sql
Beitrag von: richard2 am 23 Januar 2004, 07:56:40
Ferhler gefunden:
Man darf bei "Name für unangemeldete User: " keine "" verwenden