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.
SOFTWARE: Each software has it's own forum. Software here is NOT supported. Posts about this software will be deleted. Supported software questions ONLY please.
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.

MYSQLi DATABASE ERROR After Initial Install - DreamhostPosts in the Maian Support forum by stevendaysr
stevendaysr
31-10-2021 15:01:39

I installed your Maian helpdesk software at my stevendaysr.com domain hosted at Dreamhost on a shared hosting plan. Everything went smoothly and the final popup said the installation succeeded and gave me my admin login URL. When I tried to log into my helpdesk admin I received a database error message (see error at https://stevendaysr.com/helpdesk/admin/index.php). Here is the information I received from my Dreamhost support staff:

"Upon reviewing your installation, I found out that you are using a PHP Support ticketing software, called Maian Support. Checking their site for server requirements shows that they should be compatible with your shared hosting plan. However, the database error you are getting, upon further check seems to stem from the MySQL 8 version (latest) that we are using on our servers.

Although the Maian support page says it requires MySQL 5.6 or above, but their last update for the said software was still Version 4.3 (09/03/2020), which is more than a year ago (https://www.maiansupport.com/changelog.html). As mentioned, this is a MySQL 8 incompatibility."

I really like your helpdesk software as I have used it before. Can you kindly provide any information to fix this problem?

Hotstryker
24-01-2022 17:51:52

Dreamhost just migrated my VPS/SQL to the new MySQL8 servers and I am now getting errors and can not access my support site.  The error I get is...

MySQLi Error on 20 January 2022 @ 10:53AM
Code: 1231
Error: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
File: 37
Line: /home/jsinley/sinleymarketing.com/helpdesk/control/lib/db.php
DB Query:

SET `sql_mode` = 'IGNORE_SPACE,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

maiandavid
24-01-2022 23:35:36

The current version doesn't officially support 8.0, the next version (currently in beta) should be ok.

Try opening the 'control/lib/db.php' file and changing line 37 to:

mswSQL_query("SET `sql_mode` = ''", __file__, __line__);
David - Lead Developer/Programmer
www.maianmedia.com
100% Free SoftwareSoftware Versions, Development, Docs & UpgradesHostingNewsletter
Made with in the U.K & Hong Kong

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