Community Forum

Please read the intro before joining/posting. Thank you.

If you have questions about our software, chances are this forum has the answers.

You'll need to register before you can post on the forum to ask your question or to answer another one. A reply will be posted to each and every question that is asked so there is no need to double post or bump your post. We'll do our best to answer promptly, but in some cases it may take a day or two. If you bump your post, it may be removed. Bear with us and we'll get your question answered quickly.

Here are a few tips to help you to get your questions answered more rapidly.

IMPORTANT: Posts in English only. We don't employ translators and we'll be unable to understand your message properly and will probably delete it.
SEARCH: Use the search option to see if your question has been answered on the forum before now or if there is an answer in the documentation of your software.
PERSONAL SUPPORT: If you have purchased a commercial version of any software, using the contact option at the licence centre ensures a faster response.
AUTO DELETION: Accounts older than 5 days, with no posts or topics, are automatically deleted. Only register if you are thinking of posting.
LINKS: Any links posted are not clickable (to deter spammers) and must be copied / pasted into your browser address bar.

            

You are not logged in.

HELP -- Got System/Ajax Error after upgrading from version 3.1 to 3.2Posts in the Maian Greetings forum by jj268
jj268
09-04-2022 19:11:03

Hi there,

Maian Greetings software has two errors/issues on my website: https://www.uswebcity.com/cards/

(1). After upgrading  Maian Greetings from version 3.1 to 3.2 with (a commercial version), when I try to click on the Preview or Send Ecard button for sending an ecard, I get this System Error message below.

SYSTEM ERROR
A problem has occurred with the server request.
Please try again or view the logs to see if an error has been logged preventing the ajax request completing.

Here is my ecard's URL: https://www.uswebcity.com/cards/

(2). Also the "Upload Image" to send as an ecard feature is not working.
After I select an image from my computer, it does not show on the screen/ecard, so I cannot upload the image file.

Could you please help me to fix the two issues? So people are able to send ecards. Thank you very much.

maiandavid
10-04-2022 12:11:49

Sorry to hear you have encountered issues. Is there any log in the logs' folder?

David - Lead Developer/Programmer
www.maianmedia.com
jj268
10-04-2022 19:31:13

Hi David,
Thanks for your prompt reply. Attached is the log file below. Thank you.

===========================================================================

Date/Time: 8 April 2022 @ 15:02:13
Code: 1146
Error: Table 'dbs58012.mgr_ecards_poems' doesn't exist
File: /homepages/33/d1380xxxx/htdocs/cards/control/classes/system/class.db.php
Line: 502
Message : 

SELECT count(*) AS `r_count` FROM `mgr_ecards_poems`

===========================================================================
Date/Time: 8 April 2022 @ 17:43:03
Code: 1064
Error: 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 ')
             
             GROUP BY `mgr_ecards_category`.`ec' at line 11
File: /homepages/33/d1380xxxx/htdocs/cards/control/classes/system/class.db.php
Line: 502
Message : 

SELECT SQL_CALC_FOUND_ROWS *,
             `mgr_ecards`.`name` AS `eName`,
             `mgr_ecards`.`slug` AS `eSlug`,
             `mgr_ecards`.`id` AS `eID`
             FROM `mgr_ecards_category`
             LEFT JOIN `mgr_ecards`
             ON `mgr_ecards`.`id` = `mgr_ecards_category`.`ecard`
             LEFT JOIN `mgr_categories`
             ON `mgr_categories`.`id` = `mgr_ecards_category`.`category`
             WHERE `mgr_ecards`.`en` = 'yes'
             OR (MATCH(`mgr_ecards`.`name`) AGAINST('Happy*' IN BOOLEAN MODE) OR MATCH(`mgr_ecards`.`description`) AGAINST('Happy*' IN BOOLEAN MODE) OR `mgr_ecards`.`tags` LIKE 'Happy') OR (`mgr_ecards`.`name` LIKE '%New%' OR `mgr_ecards`.`description` LIKE '%New%' OR `mgr_ecards`.`tags` LIKE '%New%') OR (MATCH(`mgr_ecards`.`name`) AGAINST('Year*' IN BOOLEAN MODE) OR MATCH(`mgr_ecards`.`description`) AGAINST('Year*' IN BOOLEAN MODE) OR `mgr_ecards`.`tags` LIKE 'Year') )
             
             
             GROUP BY `mgr_ecards_category`.`ecard`
             ORDER BY `mgr_ecards`.`name`,`mgr_ecards`.`ts` DESC
             LIMIT 0,15

===========================================================================

Date/Time: 9 April 2022 @ 05:59:24
Code: 1064
Error: 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 ')
             
             
             GROUP BY `mgr_ecards_category`.`ec' at line 11
File: /homepages/33/d1380xxxx/htdocs/cards/control/classes/system/class.db.php
Line: 502
Message : 

SELECT SQL_CALC_FOUND_ROWS *,
             `mgr_ecards`.`name` AS `eName`,
             `mgr_ecards`.`slug` AS `eSlug`,
             `mgr_ecards`.`id` AS `eID`
             FROM `mgr_ecards_category`
             LEFT JOIN `mgr_ecards`
             ON `mgr_ecards`.`id` = `mgr_ecards_category`.`ecard`
             LEFT JOIN `mgr_categories`
             ON `mgr_categories`.`id` = `mgr_ecards_category`.`category`
             WHERE `mgr_ecards`.`en` = 'yes'
             OR (MATCH(`mgr_ecards`.`name`) AGAINST('MidAutumn*' IN BOOLEAN MODE) OR MATCH(`mgr_ecards`.`description`) AGAINST('MidAutumn*' IN BOOLEAN MODE) OR `mgr_ecards`.`tags` LIKE 'MidAutumn') OR (MATCH(`mgr_ecards`.`name`) AGAINST('Festival*' IN BOOLEAN MODE) OR MATCH(`mgr_ecards`.`description`) AGAINST('Festival*' IN BOOLEAN MODE) OR `mgr_ecards`.`tags` LIKE 'Festival') )
             
             
             GROUP BY `mgr_ecards_category`.`ecard`
             ORDER BY `mgr_ecards`.`name`,`mgr_ecards`.`ts` DESC
             LIMIT 0,15

===========================================================================

Date/Time: 9 April 2022 @ 19:43:03
Code: 1064
Error: 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 's request. Other additional, optional information is also requested from the use' at line 26
File: /homepages/33/d1380xxxx/htdocs/cards/control/classes/system/class.db.php
Line: 502
Message : 

UPDATE `mgr_settings` SET
    `website`    = '美網賀卡城 - 免費電子賀卡 Free Greeting Cards',
    `email`      = 'xxxxx@yahoo.com',
    `metadesc`   = '',
    `metakeys`   = '',
    `language`   = 'english',
    `ifolder`    = 'https://www.uswebcity.com/cards/',
    `bfolder`    = '',
    `dateformat` = 'j M Y',
    `timeformat` = 'H:iA',
    `timezone`   = 'America/Adak',
    `calformat`  = 'dd/mm/yyyy',
    `weekstart`  = 'sun',
    `afoot`      = '© 2005-2022 <a href=\"../../cards\" class=\"navLink3\">美網賀卡城 USWebCity</a>. All Rights Reserved. 美網城',
    `pfoot`      = 'Copyright © 2022 美網賀卡城 <a href=\"../index.html\" target=\"_blank\">USWebCity</a>. All rights reserved. <a href=\"../privacypolicy.html\" target=\"_blank\">Privacy Policy</a>',
    `modr`       = 'no',
    `cache`      = 'yes',
    `cachetime`  = '30',
    `autodel`    = '180',
    `autodel2`   = '180',
    `enotify`    = 'yes',
    `dismsc`     = 'yes',
    `cronlimit`  = '8',
    `uploads`    = 'yes',
    `recipients` = '5',
    `pr`         = '<h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">Our Commitment to Privacy</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">U.S. Webcity ("the company") &nbsp;recognizes your right to confidentiality and is committed to protecting your privacy.</p><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">You can visit the company online without telling us who you are or revealing any information about yourself.&nbsp; Our web server only collects domain names, and not the email addresses of our visitors. We use this information to study traffic patterns to our site-when people visit, the number of pages viewed, average time spent, most frequently visited areas, etc. This analysis is helpful for improving the content and structure of our site.</p><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">This privacy statement applies solely to information collected by the company web sites.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">The Information We Collect</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">There are times when it is important for us to request information from you. Such requests may be part of online surveys, contests, feedback, registration and/or order forms. Some of our forms require users to provide contact information which we use to process the user's request. Other additional, optional information is also requested from the user to determine the demographics of our audience. For example, we might ask for:</p><ul style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;"><li>Name</li><li>Title</li><li>Company Name</li><li>Address</li><li>E-mail Address</li></ul><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">The Way We Use Information</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">At no time will the company sell, trade, rent or distribute personal information to any outside organization. We use email addresses to send requested information and respond to the email we receive. Information such as name, title and company information is used to determine the demographics of our audience and help us to present the information of most value to those who visit.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">The Use of Cookies</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">A "cookie" is a small file that your web browser places on your computer's hard drive to store important data. A cookie cannot be executed as code or deliver viruses. Cookies save you time by enabling your browser to keep track of information such as passwords and customer account information. The cookies that we use will expire as soon as you close your browser.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">Rejecting Cookies</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">You have the option of setting your browser to reject cookies. In most cases, if you do not accept the cookie you are still able to use the site, however you will not be able to utilize advanced features.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">Opting-Out</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">We provide the opportunity to opt-out of receiving communications from the company at the point where we request information about you and in each instance when you receive material from us. If you have difficulty in opting-out in this manner, please contact us and provide your name, email address and subscription you wish to cancel.</p><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">Our goal is to respect your privacy. To help us improve our policies, we welcome your feedback.</p><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">To protect your privacy, we have adopted the following principles:</p><ul style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;"><li>Notice</li><li>Choice</li><li>Security</li></ul><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">Notice</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">Where the company collects Personal Information on the web, we intend to post a purpose statement that explains why Personal Information will be collected and whether we plan to share such Personal Information outside of the company or those working on the company's behalf. the company does not intend to transfer Personal Information without your consent to third parties who are not bound to act on the company's behalf unless such transfer is legally required.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">Choice</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">You may choose whether or not to provide Personal Information to the company. The notice we intend to provide where the company collects Personal Information on the Web should help you to make this choice. If you choose not to provide the Personal Information we request, you can still visit most of the company's Web sites, but you may be unable to access certain options, offers, and services that involve our interaction with you. If you chose to have a relationship with the company, such as a contractual or other business relationship or partnership, we will naturally continue to contact you in connection with that business relationship.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">Security</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">Wherever your Personal Information may be held within the company or on its behalf, we intend to take reasonable and appropriate steps to protect the Personal Information that you share with us from unauthorized access or disclosure.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">Children's Privacy</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">The company is not structured to attract children. Accordingly, we do not intend to collect Personal Information from anyone we know to be under 13 years of age.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">How to Update Your Personal Information</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">If you have already registered with the company and your interests or contact information has changed, please resubmit your information.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">How to Contact the company Regarding Your Privacy</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">Please contact us using the&nbsp;<a href="https://www.uswebcity.com/contact.html" style="color: blue;">Info Request Form</a>.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">Public Forums - Feedback</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">This site may make chat rooms, forums, message boards, feedback forms and/or news groups available to its users. Please remember any information disclosed in these areas becomes public information and you should exercise caution when deciding to disclose your personal information.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">Our Commitment to Data Security</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">To prevent unauthorized access, maintain data accuracy, and ensure the correct use of information, we have put in place appropriate physical, electronic and managerial procedures to safeguard and secure the information we collect online.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">Links to Non-the company Web Sites</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">The company may provide links to Internet sites maintained by others. The company does not review all of such third party web sites linked to the site and is not responsible for the contents of, or any products or services offered, in such third party sites.</p><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">We encourage our users to be aware when leaving the company web sites and to read the privacy statements of each and every web site that collects personally identifiable information.</p><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">The company provides these links to you as a convenience, and the inclusion of any link does not imply endorsement or acceptance of responsibility of non-the company web sites.</p><h5 style="color: rgb(0, 0, 0); font-family: arial, helvetica;">Contacting Us</h5><p style="font-family: arial, helvetica; color: rgb(0, 0, 0); font-size: medium;">If visitors have any questions regarding the www.uswebcity.com privacy policy, please feel free to&nbsp;<a href="https://www.uswebcity.com/contact.html" style="color: blue;">contact us</a>&nbsp;via e-mail. All trademarks are the property of their respective owners.</p>',
    `pr_areas`   = 'a:3:{i:0;s:3:"crd";i:1;s:3:"con";i:2;s:3:"upl";}',
    `viswyg`     = 'yes'

===========================================================================

Date/Time: 10 April 2022 @ 04:32:23
Code: 1064
Error: 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 ')
             
             
             GROUP BY `mgr_ecards_category`.`ec' at line 11
File: /homepages/33/d138xxxxxxx/htdocs/cards/control/classes/system/class.db.php
Line: 502
Message : 

SELECT SQL_CALC_FOUND_ROWS *,
             `mgr_ecards`.`name` AS `eName`,
             `mgr_ecards`.`slug` AS `eSlug`,
             `mgr_ecards`.`id` AS `eID`
             FROM `mgr_ecards_category`
             LEFT JOIN `mgr_ecards`
             ON `mgr_ecards`.`id` = `mgr_ecards_category`.`ecard`
             LEFT JOIN `mgr_categories`
             ON `mgr_categories`.`id` = `mgr_ecards_category`.`category`
             WHERE `mgr_ecards`.`en` = 'yes'
             OR (MATCH(`mgr_ecards`.`name`) AGAINST('Happy*' IN BOOLEAN MODE) OR MATCH(`mgr_ecards`.`description`) AGAINST('Happy*' IN BOOLEAN MODE) OR `mgr_ecards`.`tags` LIKE 'Happy') OR (MATCH(`mgr_ecards`.`name`) AGAINST('Thanksgiving*' IN BOOLEAN MODE) OR MATCH(`mgr_ecards`.`description`) AGAINST('Thanksgiving*' IN BOOLEAN MODE) OR `mgr_ecards`.`tags` LIKE 'Thanksgiving') OR (`mgr_ecards`.`name` LIKE '%Day%' OR `mgr_ecards`.`description` LIKE '%Day%' OR `mgr_ecards`.`tags` LIKE '%Day%') )
             
             
             GROUP BY `mgr_ecards_category`.`ecard`
             ORDER BY `mgr_ecards`.`name`,`mgr_ecards`.`ts` DESC
             LIMIT 0,15

===========================================================================
maiandavid
11-04-2022 03:19:23

Ok, let's start with this one"
"Error: Unknown column 'mgr_ecards_log.upload' in 'where clause'"

That's a missing column which should be added during upgrade. You did run the upgrade routines?

David - Lead Developer/Programmer
www.maianmedia.com
jj268
12-04-2022 03:28:34

Yes, I have ran the upgrade already. What're the next steps for fixing the issues? Thanks.

maiandavid
12-04-2022 09:07:23

Until I know what the problem is, your guess is as good as mine. lol.

So, you need to run the upgrade again and log the upgrades, so:

1. Make sure your install directory exists again.
2. Open the 'install/control/config.php" file and enable the upgrade log:

define('MSW_UPGRADE_LOG', 1);

3. Access the 'install/upgrade.php' file again and use the dropdown to revert the system back to the previous version. Then run the upgrade again and tell me what errors appear in the 'logs' folder.

David - Lead Developer/Programmer
www.maianmedia.com
jj268
13-04-2022 03:41:07

Hi David, I have reran the upgrade. The upgrade log is below. But I still have the same issues. When you have a chance, can you try checking my website? Thank you very much.

Script: Maian Greetings
Script Version: 3.2
PHP Version: 7.4.28
Server Software: Apache
Platform: Windows
===========================================================================
Operation/Detail: System Offline
---------------------------------------------------------------------------
Operation/Detail: Check all live indexes are set
---------------------------------------------------------------------------
Operation/Detail: Index "flag => em" exists in blocked and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "slug => slug" exists in ecards and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Fulltext Index "name => name" exists in ecards and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Fulltext Index "description => description" exists in ecards and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "ecard => ev" exists in ecards_category and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "category => cat" exists in ecards_category and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "rid => rid" exists in ecards_history and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "lid => lid" exists in ecards_history and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "eid => eid" exists in ecards_history and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "ts_send => ts_send" exists in ecards_log and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "eid => eid" exists in ecards_log and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "ts => ts" exists in ecards_log and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Fulltext Index "name => name" exists in ecards_log and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Fulltext Index "email => email" exists in ecards_log and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Fulltext Index "message => message" exists in ecards_log and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "eid => eid" exists in ecards_rec and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "code => code" exists in ecards_rec and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "emailed => emailed" exists in ecards_rec and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "notify => notify" exists in ecards_rec and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "lid => lid" exists in ecards_rec and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "lid => lid" exists in ecards_uploads and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "ts => ts" exists in ecards_uploads and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index "desc => descK" exists in social and will be ignored
---------------------------------------------------------------------------
Operation/Detail: Index file already exists in: /homepages/33/d1xxxxxxxx/htdocs/cards/control/system/../../admin/backup
---------------------------------------------------------------------------
Operation/Detail: Index file already exists in: /homepages/33/d1xxxxxxxx/htdocs/cards/control/system/../../content/ecard-files
---------------------------------------------------------------------------
Operation/Detail: Index file already exists in: /homepages/33/d1xxxxxxxx/htdocs/cards/control/system/../../content/emojis
---------------------------------------------------------------------------
Operation/Detail: Index file already exists in: /homepages/33/d1xxxxxxxx/htdocs/cards/control/system/../../content/music
---------------------------------------------------------------------------
Operation/Detail: Index file already exists in: /homepages/33/d1xxxxxxxx/htdocs/cards/control/system/../../logs
---------------------------------------------------------------------------
Operation/Detail: Version updated to 3.2
---------------------------------------------------------------------------
Operation/Detail: System back online
---------------------------------------------------------------------------
maiandavid
13-04-2022 05:01:42

There should be more entries than that. Yes, I can check for you. If you have a commercial licence, use the personal support option to send me your details.

https://www.maiangateway.com

I'll need ftp access to your greetings setup.

David - Lead Developer/Programmer
www.maianmedia.com
100% Free SoftwareSoftware Versions, Development, Docs & UpgradesHostingNewsletter
Made with in the U.K & Hong Kong

Free PHP Software / Responsive PHP Scripts / Lightweight PHP Software / White Label PHP Software