Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

install : MysqlDB m...
 
Notifications
Clear all

install : MysqlDB missing ?

13 Posts
2 Users
0 Reactions
18.2 K Views
 Sky
(@sky)
Posts: 10
Active Member
Topic starter
 
[#199]

Hi

I just download projectorria on XAMPP light (Apache, MySQL, no python)

When I go to the mail page, it redirects to projectorria/view/main.php
and display the message :
ERROR : Impossible to load class mysqlDB
=> Not found in ../model/MysqlDB.php
=> Not found in ../model/persistence/MysqlDB.php

No more information is shown.
Can projectorria runs on XAMP or is there a problem ?

Thanks for help
Sky


 
Posted : 19 Sep 2011 20H25
(@babynus)
Posts: 14952
Member Admin
 

Hi,

No issue to run or XAMPP or XAMPP Lite (I just tried, it's OK).
Just pay attention that Lite version does not include mail functionality, so automatic emailing on status change may not work.
But this should not lead to an error.

Could you :
- precise conditions of production of the error (print screen ?)
- have a look at the log file after producing the error.

Thanks.


 
Posted : 19 Sep 2011 22H26
 Sky
(@sky)
Posts: 10
Active Member
Topic starter
 

Hi

Well, I should probably see the install page. Instead of that, I get a blank one with the message :
ERROR : Impossible to load class mysqlDB
=> Not found in ../model/MysqlDB.php
=> Not found in ../model/persistence/MysqlDB.php

No more.
Sometimes HTML code can help, so here it is :

ERROR : Impossible to load class mysqlDB
=> Not found in ../model/MysqlDB.php
=> Not found in ../model/persistence/MysqlDB.php

I suppose you ask about apache log ?
Here is the access log :
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/ HTTP/1.1" 200 1414 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/img/logo.ico HTTP/1.1" 200 326 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/css/projector.css HTTP/1.1" 200 52474 " http://127.0.0.1/projectorria/ " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/css/FileInput.css HTTP/1.1" 200 1193 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/css/common.css HTTP/1.1" 200 54908 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/css/projectorIcons.css HTTP/1.1" 200 32158 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/external/dojo/resources/dojo.css HTTP/1.1" 200 1571 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/external/dijit/themes/dijit.css HTTP/1.1" 200 29460 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/external/dijit/icons/commonIcons.css HTTP/1.1" 200 4408 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/img/logoFull.gif HTTP/1.1" 200 5458 " http://127.0.0.1/projectorria/ " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/img/titleFull.gif HTTP/1.1" 200 5849 " http://127.0.0.1/projectorria/ " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/css/images/spinner10.gif HTTP/1.1" 200 3289 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "POST /projectorria/view HTTP/1.1" 301 385 " http://127.0.0.1/projectorria/ " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/ HTTP/1.1" 200 1527 " http://127.0.0.1/projectorria/ " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/img/logo.ico HTTP/1.1" 200 326 "-" "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/css/projector.css HTTP/1.1" 200 52474 " http://127.0.0.1/projectorria/view/ " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/css/common.css HTTP/1.1" 200 54908 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/external/dijit/icons/commonIcons.css HTTP/1.1" 200 4408 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/external/dijit/themes/dijit.css HTTP/1.1" 200 29460 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/css/projectorIcons.css HTTP/1.1" 200 32158 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/external/dojo/resources/dojo.css HTTP/1.1" 200 1571 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/view/css/FileInput.css HTTP/1.1" 200 1193 " http://127.0.0.1/projectorria/view/css/projector.css " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:56 +0200] "GET /projectorria/external/dojo/dojo.js HTTP/1.1" 200 91815 " http://127.0.0.1/projectorria/view/ " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:06:57 +0200] "POST /projectorria/view/main.php HTTP/1.1" 200 346 " http://127.0.0.1/projectorria/view/ " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:07:04 +0200] "POST /projectorria/view/main.php HTTP/1.1" 200 346 " http://127.0.0.1/projectorria/view/ " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:07:58 +0200] "POST /projectorria/view/main.php HTTP/1.1" 200 346 " http://127.0.0.1/projectorria/view/ " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"
127.0.0.1 - - [20/Sep/2011:09:08:02 +0200] "POST /projectorria/view/main.php HTTP/1.1" 200 346 " http://127.0.0.1/projectorria/view/ " "Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3 (.NET CLR 3.5.30729)"

error.log :
[Tue Sep 20 09:06:51 2011] [warn] pid file G:/Application/Web/xampp_disk_g/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Tue Sep 20 09:06:51 2011] [notice] Digest: generating secret for digest authentication ...
[Tue Sep 20 09:06:51 2011] [notice] Digest: done
[Tue Sep 20 09:06:54 2011] [notice] Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Tue Sep 20 09:06:54 2011] [notice] Server built: Oct 18 2010 01:58:12
[Tue Sep 20 09:06:54 2011] [notice] Parent: Created child process 5460
[Tue Sep 20 09:06:55 2011] [notice] Digest: generating secret for digest authentication ...
[Tue Sep 20 09:06:55 2011] [notice] Digest: done
[Tue Sep 20 09:06:56 2011] [notice] Child 5460: Child process is running
[Tue Sep 20 09:06:56 2011] [notice] Child 5460: Acquired the start mutex.
[Tue Sep 20 09:06:56 2011] [notice] Child 5460: Starting 150 worker threads.
[Tue Sep 20 09:06:56 2011] [notice] Child 5460: Starting thread to listen on port 443.
[Tue Sep 20 09:06:56 2011] [notice] Child 5460: Starting thread to listen on port 80.

Do you see something wrong ?
Thanks


 
Posted : 20 Sep 2011 11H14
 Sky
(@sky)
Posts: 10
Active Member
Topic starter
 

Hi

I try to have a glance to the code, even if I am not an PHP expert, mostly a newbie...

I put trace in tool/projector.php :

Not found in ../model/MysqlDB.php
=> Not found in ../model/persistence/MysqlDB.php

So the issue seems to be related to session_start(), not ?

If I try :
Not found in ../model/MysqlDB.php
=> Not found in ../model/persistence/MysqlDB.php

Does it helps ?
Sky


 
Posted : 20 Sep 2011 16H40
(@babynus)
Posts: 14952
Member Admin
 

Hi,
Thanks for this helpfull traces.
Very strange, because :
- it shows error appearing on session_start() (as you identified it)
- I tried it yesterday with a blank install and did not get the issue.
- there is no reference to mysqlDB class in aplication code
- with your test, you should get the error : Cannot send session cookie - headers already sent by... because it is illegal to have an echo before session_start() (no output is allowed before).

Could you try to remove your first echo ("aaaaaaa") and re-test ? does it show "bbbbbbb" ?
On what OS are your testing ?

Regards.


 
Posted : 20 Sep 2011 18H30
 Sky
(@sky)
Posts: 10
Active Member
Topic starter
 

Hi

As said in the previous message (or I do not have understood your request, let me know), if I try :
Not found in ../model/MysqlDB.php
=> Not found in ../model/persistence/MysqlDB.php

The OS is Win XP PRo, xampp is get from http://portableapps.com /, download on an external disk, and only apache and SQL are started.

After some research , the calling function is toolprojector.php:344:function __autoload($className)

I just try a (stupid) idea : create an empty MysqlDB.php file in model directory.

A page starting with :
"Configuration
This screen will help you configure Project'Or RIA at first run. "
followed by a long form is now displayed.

May be it can be a workaround, but I still ignore the real cause.
I will try this way to see if I can go further with this patch.

If you want, I can do a second install to try few test for you.
I hope it helps and thanks for your helps

Sky


 
Posted : 20 Sep 2011 19H34
 Sky
(@sky)
Posts: 10
Active Member
Topic starter
 

Hi

Ok, with an empty MysqlDB.php file created in model directory, the main configuration page is displayed.
Once filled and submitted, the database is created with no structure (only the name of the base exists, no table).
Then the login page is displayed. Of course, it is not possible to login or use projectorria as there is no database.

So this is a bottleneck.
Any idea is welcome.
Sky


 
Posted : 20 Sep 2011 20H04
 Sky
(@sky)
Posts: 10
Active Member
Topic starter
 

Hi

I put a var_dump(debug_backtrace()); in projector.php / __autoload function (thanks to google and web forums !)

Here is the result :

array(3) {
[0]=> array(2) { ["function"]=> string(10) "__autoload" ["args"]=> array(1) { [0]=> &string(7) "mysqlDB" } }

[1]=> array(4) { ["file"]=> string(70) "G:ApplicationWebxampp_disk_ghtdocsprojectorriatoolprojector.php" ["line"]=> int(2) ["function"]=> string(13) "session_start" ["args"]=> array(0) { } }

[2]=> array(4) { ["file"]=> string(65) "G:ApplicationWebxampp_disk_ghtdocsprojectorriaviewmain.php" ["line"]=> int(10) ["args"]=> array(1) { [0]=> string(70) "G:ApplicationWebxampp_disk_ghtdocsprojectorriatoolprojector.php" } ["function"]=> string(12) "require_once" } }

What did session start does ?
How may I trace the code ?

Thanks
Sky


 
Posted : 20 Sep 2011 20H27
(@babynus)
Posts: 14952
Member Admin
 

Hi,
First, thanks for all these informations.

=> I did not try the protable version of xampp. I will try it to try and reproduce.

=> Your workaround seems to be good. But I don't understand why. I will invertigate.

=> If you come to the login screen, you're on the good way. If the database is empty, it's normal, it is automatically generated at first login. Just login as admin/admin.

=> all your traces confirm that the issue is raised on the session_start() command. It is very strange as the session_start() is an internal PHP command. There is no reason for it to call a MysqlDB class. The location of error in __autoload function is normal : it is an internal function that fetches the correct class in the correct directory.

=> Just writing previous lines, I just had an idea : could you search in you PHP installation directory for a MysqlDB.php file ? It could be a class used on session_start() in this typical distribution. As the __autoload() changes the place where to look for classes, it could lead to this strange behaviour.

Regards.


 
Posted : 20 Sep 2011 21H37
(@babynus)
Posts: 14952
Member Admin
 

Hi,
I try to reproduce, but can not find the lite version on http://portableapps.com .
I'd like to find exactly the version you installed, to be able to reproduce.
Which version exactely did you download ? (if you have a full link...)
Is it V1.7.4, V1.7.5 (maybe not V1.7.7, which is just 8 hours old...) ?
Installer or zip ?
What is the size of the downloaded file ?

Thanks.


 
Posted : 20 Sep 2011 21H52
(@babynus)
Posts: 14952
Member Admin
 

Hi,
I tried with xampp-win32-1.7.5-usb-lite.exe, on usb, running on vista.
No issue.
I will try later on XP PRO.

Just notice that performance is very bad running on USB.
Creation of tables at first run longed more than 2 minutes.
On an EasyPHP, locally installed not on USB, this step last less than 3 seconds on the same machine.

Regards.


 
Posted : 20 Sep 2011 22H21
 Sky
(@sky)
Posts: 10
Active Member
Topic starter
 

Hi

The xampp I use : xampp-win32-1.7.4-VC6-installer.exe, size 66 303 148
If necessary I can use another version without problem

Search MysqlDB on the whole external disk : no result

Search MysqlDB in *.php on the whole external disk : found ! In another project (projecttimer) not running, installed in another directory on xampp server ! Once this directory removed, the issue is still there 🙁

Note : As the disk is also use to save data, in another directory, there is EasyPhp 5.3.0, not started of course, just here as backup from my PC

Back to the patch (add a empty model/MysqlDB.php file) + login as admin / admin : database created and application can be started. It seems to worth the effort, may be THE application I was looking for since months... I need to explore more to check if anything works.

I can still do testing on a copy of projectorria if it can help you.
Thanks for all
Regards
Sky


 
Posted : 21 Sep 2011 19H08
(@babynus)
Posts: 14952
Member Admin
 

Hi,

I just tried to install exactly your version xampp-win32-1.7.4-VC6-installer.exe.
Running Project'Or RIA => no issue.
Then trying to install ProjectTimer : many warnings send, some referencing mysqlDB.php.
Trying Project'Or RIA again : got the issue !

ERROR : Impossible to load class mysqlDB
=> Not found in ../model/MysqlDB.php 
=> Not found in ../model/persistence/MysqlDB.php

So ProjectTimer sets a mess in PHP server.

Restart xampp server.
Run Project'Or RIA => issue is still there

Stop xampp server.
Delete session temp files (in /tmp directory).
Start xampp server.
Run Project'Or RIA => issue is not there any more. All is fine !

So ProjetTimer set some things in session data that sets the mess in the server...
Solution => delete tmp session files before running Project'Or RIA.

Regards.


 
Posted : 22 Sep 2011 16H38
Share:

Scroll to Top