Skip to Content Skip to Menu

🌲 Merry Christmas! Great savings on Professional and Developer Memberships! Get 25% off now with code XMAS-2024!

Message Control Center is not working

  • smFruen
  • smFruen
  • OFFLINE
  • Posts: 116
  • Thanks: 5
  • Karma: 3
8 years 6 months ago #282316 by smFruen
Message Control Center is not working was created by smFruen
Message Control Center is not working,

An error has occurred.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ufrom.username LIKE 'a%'' at line 1 SQL=SELECT count(id) FROM `#__uddeim` WHERE `delayed`<>0 ufrom.username LIKE 'a%'

I use:
Premium Plugins 3.8
and uddeIM 3.8

because vertion 3.9 gives a ? instead of æøå

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

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
8 years 6 months ago #282324 by slabbi
Replied by slabbi on topic Message Control Center is not working
Please can you change line 45 in admin.mcp.php from
Code:
$where = count($f_where) ? " WHERE " ...

to
Code:
$f_where[] = "`delayed`<>0"; $where = " WHERE " . implode(' AND ', $f_where);

This should fix the bug.

Thanks for reporting!

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

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

  • smFruen
  • smFruen
  • OFFLINE
  • Posts: 116
  • Thanks: 5
  • Karma: 3
8 years 6 months ago #282325 by smFruen
Replied by smFruen on topic Message Control Center is not working
on line 45

my say

$where = count($f_where) ? " WHERE `delayed`<>0 " . implode(' AND ', $f_where) : " WHERE `delayed`<>0";


?

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

  • slabbi
  • slabbi
  • OFFLINE
  • Posts: 3709
  • Thanks: 250
  • Karma: 153
8 years 6 months ago #282326 by slabbi
Replied by slabbi on topic Message Control Center is not working
I shortened the code above. It is the correct line.

uddeIM & uddePF Development
CB Language Workgroup
CB 3rd Party Developer

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

  • smFruen
  • smFruen
  • OFFLINE
  • Posts: 116
  • Thanks: 5
  • Karma: 3
8 years 6 months ago #282327 by smFruen
Replied by smFruen on topic Message Control Center is not working
it is not working




now it say


En fejl er opstået

1054 Unknown column 'ufrom.username' in 'where clause' SQL=SELECT count(id) FROM `#__uddeim` WHERE ufrom.username LIKE 'b%' AND `delayed`<>0

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

  • smFruen
  • smFruen
  • OFFLINE
  • Posts: 116
  • Thanks: 5
  • Karma: 3
8 years 6 months ago #282328 by smFruen
Replied by smFruen on topic Message Control Center is not working
if you like i have teamViewer

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

Moderators: beatnantslabbikrileon
Powered by Kunena Forum