an error in your SQL syntax

[hoop]

-There was an error running the query [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 '18, 'requestcount', '10')' at line 1]

-I can't add or delete Mail Account for admin  Invalid Email [admin@como.cricket]
Mails Per Clients Under localhost (0 to 0 of 0)

Code: [Select]

sh /script/sysinfo

A. Kloxo-MR: 7.0.0.b-2015042803

B. OS: CentOS release 6.6 (Final) i686

C. Apps:
   1. MySQL: mysql55-5.5.43-1.ius.el6.i686
   2. PHP: php54-5.4.40-1.ius.el6.i686
   3. Httpd: httpd-2.2.29-2.mr.el6.i386
   4. Lighttpd: --uninstalled--
   5. Hiawatha: hiawatha-9.12.0-f.4.mr.el6.i386 (also as webserver)
   6. Nginx: --uninstalled--
   7. Cache: --uninstalled--
   8. Dns: nsd-4.1.2-1.mr.el6.i386
   9. Qmail: qmail-toaster-1.03-1.3.53.mr.el6.i386
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386

D. Php-type (for Httpd/proxy): php-fpm_event

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:           512        452         59         27          0        214
   -/+ buffers/cache:        238        273
   Swap:          512        220        291


[MRatWork]

1. Is it error from of Kloxo-MR?
2. Possible something wrong with qmail. Inform here 'yum list *-toaster; hostname; hostname -s'.

[hoop]

Code: [Select]

yum list *-toaster; hostname; hostname -s
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.cogentco.com
 * extras: mirror.cs.uwp.edu
 * mratwork-epel: mirror.cogentco.com
 * mratwork-ius-stable: iad.mirror.rackspace.com
 * updates: centos.mirror.lstn.net
0 packages excluded due to repository protections
Installed Packages
autorespond-toaster.i386     2.0.5-1.4.2.mr.el6   @mratwork-release-version-arch
courier-authlib-toaster.i386 0.59.2-1.3.13.mr.el6 @mratwork-release-version-arch
courier-imap-toaster.i386    4.1.2-1.3.18.mr.el6  @mratwork-release-version-arch
daemontools-toaster.i386     0.76-1.3.7.mr.el6    @mratwork-release-version-arch
ezmlm-toaster.i386           0.53.324-1.3.9.mr.el6
                                                  @mratwork-release-version-arch
libdomainkeys-toaster.i386   0.68-1.3.7.mr.el6    @mratwork-release-version-arch
libsrs2-toaster.i386         1.0.18-1.3.7.mr.el6  @mratwork-release-version-arch
maildrop-toaster.i386        2.0.3-1.3.9.mr.el6   @mratwork-release-version-arch
qmail-pop3d-toaster.i386     1.03-1.3.53.mr.el6   @mratwork-release-version-arch
qmail-toaster.i386           1.03-1.3.53.mr.el6   @mratwork-release-version-arch
simscan-toaster.i386         1.4.0-1.4.8.mr.el6   @mratwork-release-version-arch
ucspi-tcp-toaster.i386       0.88-1.3.11.mr.el6   @mratwork-release-version-arch
vpopmail-toaster.i386        5.4.33-1.4.4.mr.el6  @mratwork-release-version-arch
Available Packages
control-panel-toaster.noarch 0.5-1.4.1.mr         mratwork-release-neutral-noarch
send-emails-toaster.noarch   0.5-1.4.1.mr         mratwork-release-neutral-noarch
spamassassin-toaster.i686    3.3.2-1.4.4.mr.el6   mratwork-release-version-arch
spamassassin-toaster.i386    3.4.0-1.4.6.mr.el6   mratwork-release-version-arch
squirrelmail-toaster.noarch  1.4.20-1.3.18.mr     mratwork-release-neutral-noarch
server1.jojhost.com
server1

[hoop]

is this qmail error?

[MRatWork]

Try reinstall with 'yum reinstall *-toaster; sh /script/fixmail-all; sh /script/restart-mail -y'.

[hoop]

Try reinstall with 'yum reinstall *-toaster; sh /script/fixmail-all; sh /script/restart-mail -y'.

same error

Alert: Invalid Email [admin@como.cricket]

[MRatWork]

Inform here screenshot (image) for error display.

[hoop]

Inform here screenshot (image) for error display.

image for error display as ( Attachment)

[MRatWork]

Ok, it's a bug because no except more 6 chars for domain extension ('cricket' in your case).

For awhile, open 'usr/local/lxlabs/kloxo/httpdocs/lib/html/lib.php' and find out '' in 'function validate_email($email) {' and then change '{2,6}' to '{2,16}'

[hoop]

Ok, it's a bug because no except more 6 chars for domain extension ('cricket' in your case).

For awhile, open 'usr/local/lxlabs/kloxo/httpdocs/lib/html/lib.php' and find out '' in 'function validate_email($email) {' and then change '{2,6}' to '{2,16}'

It is already there

Code: [Select]

function validate_email($email)
{
       $regexp = "/^([\w\!\#$\%\&\'\*\+\-\/\=\?\^\`{\|\}\~]+\.)*[\w\!\#$\%\&\'\*\+\-\/\=\?\^\`{\|\}\~]+@" ."((((([a-z0-9]{1}[a-z0-9\-]{0,6$-]{0,62}[a-z0-9]{1})|[a-z])\.)+[a-z]{2,16})|(\d{1,3}\.){3}\d{1,3}(\:\d{1,5})?)$/i";
        if (!preg_match($regexp, $email)) {
                return false;
        }
        return true;
}

[hoop]

It seems that after last updated for kloxo-mr fix the error thank you.
but i can't delete this postmaster@any domino

[MRatWork]

You can't delete all postmaster!. It's because postmaster is 'default' account for domain.