MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: hoop on 2015-04-28, 15:59:16

Title: an error in your SQL syntax
Post by: hoop on 2015-04-28, 15:59:16: -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
Title: Re: an error in your SQL syntax
Post by: MRatWork on 2015-04-28, 16:11:10: 1. Is it error from of Kloxo-MR?
2. Possible something wrong with qmail. Inform here 'yum list *-toaster; hostname; hostname -s'.
Title: Re: an error in your SQL syntax
Post by: hoop on 2015-04-29, 04:15:51: 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
Title: Re: an error in your SQL syntax
Post by: hoop on 2015-05-04, 13:57:28: is this qmail error?
Title: Re: an error in your SQL syntax
Post by: MRatWork on 2015-05-04, 17:33:14: Try reinstall with 'yum reinstall *-toaster; sh /script/fixmail-all; sh /script/restart-mail -y'.
Title: Re: an error in your SQL syntax
Post by: hoop on 2015-05-04, 19:29:30: Quote from: MRatWork on 2015-05-04, 17:33:14
Try reinstall with 'yum reinstall *-toaster; sh /script/fixmail-all; sh /script/restart-mail -y'.
same error
Quote
Alert: Invalid Email [admin@como.cricket]
Title: Re: an error in your SQL syntax
Post by: MRatWork on 2015-05-04, 19:38:15: Inform here screenshot (image) for error display.
Title: Re: an error in your SQL syntax
Post by: hoop on 2015-05-06, 14:16:31: Quote from: MRatWork on 2015-05-04, 19:38:15
Inform here screenshot (image) for error display.
image for error display as ( Attachment)
Title: Re: an error in your SQL syntax
Post by: MRatWork on 2015-05-06, 17:57:11: 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}'
Title: Re: an error in your SQL syntax
Post by: hoop on 2015-05-07, 10:00:43: Quote from: MRatWork on 2015-05-06, 17:57:11
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; }
Title: Re: an error in your SQL syntax
Post by: hoop on 2015-05-07, 10:11:04: It seems that after last updated for kloxo-mr fix the error :) thank you.
but i can't delete this postmaster@any domino
Title: Re: an error in your SQL syntax
Post by: MRatWork on 2015-05-07, 10:23:18: You can't delete all postmaster!. It's because postmaster is 'default' account for domain.