So, our journal (jpna.org) is launching in two weeks and I'm about ready to pull my hair out and then break down and cry. Everything was going very smoothly until I went to set up reviewer forms last night, and I found a blank page instead of a settings page when I went to create a reviewer form.
Let's preface this by saying that while I have some experience with C and web development from way back, but I've never dealt with PHP or mySQL before, and I really didn't think I would have to when using OJS. So please, type slowly and be patient with me here.
I've haven't been able to fix my issues just yet through the debugging procedures outlined in the FAQ (nothing in the error log, no real leads with tweaking the functions.inc.php file either). I tried to follow the advice in this thread: viewtopic.php?f=8&t=10899
, but the came into some additional problems..
-When I submit that query in myPHPAdmin (PHP is 5.4.20, mySQL is 5.5.34-cll), I get an error saying to check the manual for the proper syntax near 'LIMIT 0, 30' at line 2. So, I can't see if I have the same problem as the previous user or not - and I'm completely unfamiliar with SQL syntax.
-I was able to clear the data and template cache on the site, but that did no good.
-When I went to disable the citation manager in step 3, my change would not save
. I was able to edit other parts of Step 3 and they would save, but whenever I open step 3, the citation manager box remains checked.
What now? Any and all help would be tremendously appreciated.ETA:
I managed to get the query to work, but all I was able to see was one column titled 'setting_name' with 'metaCitations' as its only value. I click on 'Explain SQL' and see the following: https://www.dropbox.com/s/zy3gjfam8gpy0 ... tation.png
Now I'm thinking I'm on the right track, but still lost.ETA2:
Making progress. I got the same thing as the guy in the linked thread, but when I clicked to delete one of the values I got... another syntax error. I think mySQL hates me and I'm starting to look like an idiot, and this request is turning into more of a blog post. I'm now seeing this.. https://www.dropbox.com/s/4oj3s0rowfxpm4j/omgsqlbbq.pngETA3:
I finally found a roundabout way of getting those two entries deleted, and the citation assistant is now disabled. Unfortunately, the 'form items' page still loads as blank when I try to edit the review form, and I'm still clueless on that one. My error log is coming up with the scalar value error, but the log doesn't have an entry since yesterday, which I find puzzling. Sigh. The last class to load before it fails is lib.pkp.classes.notification.NotificationDAO.