To post a new support question, click the Post New Topic button below.
Current Version: 4.8.5 | Sytist Manual | Common  Issues | Feature Requests

Please log in or Create an account to post or reply to topics.
You will still receive notifications of replies to topics you are part of even if you do not subscribe to new topic emails.

Install Never Completes

G
17 posts
Sun Mar 05, 23 9:19 PM CST

Have tried 3 times including completely wiping root dir (empty) and creating another new DB. Same thing happens every time. I run the /install , MySQL shows successful connection, select continue, and it loads a blank index page with simply "Sytist Installation" at the top.  I've installed older versions several times without issue on the same VPS host, so I have no idea what the issue is. Error log pasted below, seems to be a DB issue. 




[05-Mar-2023 19:02:37 America/Los_Angeles] PHP Fatal error:  Uncaught mysqli_sql_exception: Duplicate entry '1' for key 'ms_category_layouts.PRIMARY' in /home/dh_cwn2zj/exhibitionphoto.com/install/index.php:2588
Stack trace:
#0 /home/dh_cwn2zj/exhibitionphoto.com/install/index.php(2588): mysqli_query(Object(mysqli), 'nn--n-- Dumping...')
#1 {main}
  thrown in /home/dh_cwn2zj/exhibitionphoto.com/install/index.php on line 2588
[05-Mar-2023 19:10:12 America/Los_Angeles] PHP Fatal error:  Uncaught mysqli_sql_exception: Duplicate entry '1' for key 'ms_category_layouts.PRIMARY' in /home/dh_cwn2zj/exhibitionphoto.com/install/index.php:2588
Stack trace:
#0 /home/dh_cwn2zj/exhibitionphoto.com/install/index.php(2588): mysqli_query(Object(mysqli), 'nn--n-- Dumping...')
#1 {main}
  thrown in /home/dh_cwn2zj/exhibitionphoto.com/install/index.php on line 2588
[05-Mar-2023 19:10:19 America/Los_Angeles] PHP Fatal error:  Uncaught mysqli_sql_exception: Duplicate entry '1' for key 'ms_category_layouts.PRIMARY' in /home/dh_cwn2zj/exhibitionphoto.com/install/index.php:2588
Stack trace:
#0 /home/dh_cwn2zj/exhibitionphoto.com/install/index.php(2588): mysqli_query(Object(mysqli), 'nn--n-- Dumping...')
#1 {main}
  thrown in /home/dh_cwn2zj/exhibitionphoto.com/install/index.php on line 2588
[05-Mar-2023 19:10:29 America/Los_Angeles] PHP Warning:  Undefined array key "error_reporting" in /home/dh_cwn2zj/exhibitionphoto.com/sy-admin/index.php on line 34
[05-Mar-2023 19:10:29 America/Los_Angeles] PHP Warning:  Undefined array key "error_reporting" in /home/dh_cwn2zj/exhibitionphoto.com/sy-admin/index.php on line 36
[05-Mar-2023 19:10:29 America/Los_Angeles] PHP Warning:  Undefined array key "error_reporting" in /home/dh_cwn2zj/exhibitionphoto.com/sy-admin/index.php on line 38
[05-Mar-2023 19:10:29 America/Los_Angeles] PHP Warning:  Undefined array key "error_reporting" in /home/dh_cwn2zj/exhibitionphoto.com/sy-admin/index.php on line 40
16,152 posts (admin)
Mon Mar 06, 23 6:19 AM CST

The duplicate entry errors means those tables exist already. That message shouldn't happen with a clean install.

What PHP version & MySQL version are you running?

Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
G
17 posts
Mon Mar 06, 23 11:50 AM CST

MySQL - 8.0.28-0ubuntu0.20.04.3
PHP 8.1 FastCGI

Edited Mon Mar 06, 23 12:30 PM by Gary Weldon
16,152 posts (admin)
Mon Mar 06, 23 11:55 AM CST

That MySQL 8 might be the issue. I haven't used MySQL 8. I have a fix for something with MySQL 8 in the next update (add export item fields). 

Can you change the MySQL version to something lower and try again?

Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
G
17 posts
Mon Mar 06, 23 12:36 PM CST

OK, although the old version of Sytist was running on the same instance with no problem. I don't think I can choose the version on Dreamhost but will ask support. What is recommended?

16,152 posts (admin)
Mon Mar 06, 23 12:55 PM CST

MySQL 5.7

But you if you want you can email me the hosting login info, the domain it is being installed on and where, I can try myself to see what is going on.

It could be mostly compatible with MySQL 8 and just something with the installation process.

But it won't be until tomorrow morning before I can mess with it.

Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
G
17 posts
Mon Mar 06, 23 12:56 PM CST

As another option, if we move this particular store to Sytist hosted, can I use a custom landing page? I built a landing page on the old version of Sytist, basically just embedded the Sytist photo search function into a simple index.html form.

7 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 374 times
Category: Installation
 
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

 
©2003 - 2021 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window
Loading
Close