Hi,
after successful installation of v3.79b (PHP5, MySQL5), I face a problem that really drives me mad:
On login, I get the "Cookies required" message - the browser (IE6, Firefox9 are set to "accept all cookies), and playing with the register_globals setting in the PHP.ini doesn't help either.
My MySQL database is started - by default - with the ANSI quotes setting = ON (in MySQL: SET GLOBAL SQL_MODE = "ansi";). I need ANSI by default in order to be able to run my picture DB properly (Thumbsplus).
As long as ANSI is ON, netjukebox will come with weird error messages (cookies not set, incremental updates not allowed, and some others).
When I change this setting to SET GLOBAL SQL_MODE = ''; (nothing), netjukebox works fine (by this way: it is a great program!) - at the latest when I stop and restart the DB. (And, needless to mention, my picture DB crashes ...)
Which now leads to the following question: Is it possible (in PHP) to check this MySQL parameter, switch it off, if set, and THEN run netjukebox?
Other possibility (more elegant): How to make netjukebox run even though this parameter is set?
Anyway: It took me one day to find out about this topic but I hope it helps you guys to improve your brilliant application.
My MySQL database is started - by default - with the ANSI quotes setting = ON (in MySQL: SET GLOBAL SQL_MODE = "ansi";). I need ANSI by default in order to be able to run my picture DB properly (Thumbsplus).
As long as ANSI is ON, netjukebox will come with weird error messages (cookies not set, incremental updates not allowed, and some others).
When I change this setting to SET GLOBAL SQL_MODE = ''; (nothing), netjukebox works fine (by this way: it is a great program!) - at the latest when I stop and restart the DB. (And, needless to mention, my picture DB crashes ...)
Which now leads to the following question: Is it possible (in PHP) to check this MySQL parameter, switch it off, if set, and THEN run netjukebox?
Other possibility (more elegant): How to make netjukebox run even though this parameter is set?
Anyway: It took me one day to find out about this topic but I hope it helps you guys to improve your brilliant application.
