Adding Content to a Guide problem

[Josip Knezovic]

After creating and saving a new guide, I click on “Add Content To Your New Guide” and get a blank page.  

SubjectsPlus v4.4
Wampserver 3.2.0
Apache 2.4.41
PHP 7.3.12
MySql 8.0.18

Thanks,
Libst20

[Andrew Darby]

Hi Joseph,

I see MySQL 8.x and wonder if it's the same issue:

https://github.com/subjectsplus/SubjectsPlus/wiki/Troubleshooting-4.0#When_I_install_SP_4x_I_get_blank_screens_for_the_Database_List_and_other_pages

Does this fix work?

Andrew

--
You received this message because you are subscribed to the Google Groups "SubjectsPlus" group.
To unsubscribe from this group and stop receiving emails from it, send an email to subjectsplus...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/subjectsplus/229240c8-7b21-4383-adfb-5b73f13b70e3n%40googlegroups.com.

[Josip Knezovic]

Hi Andrew,

I already tried with this but result is same.

Josip

[Jane Sandberg]

Hi Josip,

I wonder if you're running into this issue with the rank table in
MySQL 8: https://github.com/subjectsplus/SubjectsPlus/issues/1386

It looks like the screen you were trying to access relies on the rank
table: https://github.com/subjectsplus/SubjectsPlus/blob/master/control/guides/guide.php#L160

We fixed this issue by using MySQL 5.7 instead.

-Jane


On Wed, Sep 9, 2020 at 12:47 AM Josip Knezovic

> To view this discussion on the web visit https://groups.google.com/d/msgid/subjectsplus/5e9cf9c9-7376-4324-ac5e-64fe9ba65de1n%40googlegroups.com.



--
Jane Sandberg
Electronic Resources Librarian
Linn-Benton Community College
san...@linnbenton.edu / 541-917-4655
Pronouns: she/her/hers

[Josip Knezovic]

Hi Jane,

First,  I would  like to thank you for the solution that solved my problem. 

Now there are similar problems when I try to edit a record:

Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1064 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 ', rank.subject_id, title_id, so.source_id, rank_id, description_override, subjec' at line 1 in C:\wamp64\www\sp\lib\SubjectsPlus\Control\Querier.php on line 89

I guess that I should change the queries somewhere in the code again.

I also tried with MySQL version 5.7 but I have problems starting the service.

Josip

[Andrew Darby]

Hi Josip,

So did you try to change the references to the rank table to use backticks rather than scaling down to MySQL 5.7?

Andrew

To view this discussion on the web visit https://groups.google.com/d/msgid/subjectsplus/3826f0b1-eb48-4789-871c-2555e51f11c0n%40googlegroups.com.