Database connection error in latest CVS

[avbitton]

I'm experiencing the following problem:

Fatal error: Call to undefined function: mysql_connect() in /var/www/dotproject/lib/adodb/drivers/adodb-mysql.inc.php on line 326

I see this when I try to run upgrade_permissions.php during setup. From the interface, I simply cannot log in as 'admin.'

I'm running Debian+Apache2+MySql4.1. The stable release works fine. Config.php is properly set up as are permissions to the database.

Please help.

Thanks.

[ajdonnison]

Latest CVS doesn't require upgrade_permission.php to be run manually. You must run the install/index.php ONLY.

[avbitton]

Thanks for the quick response. My permissions are set up with config.php and the files and locales/en folders set to 777 just for the install. Now I'm getting the following errors:

Applying database updates
There were 63 errors in 198 SQL statements

Warning: fopen(/web/Wicked.127/www.wickedpictures.com/htdocs/dotproject/db/upgrade_20alpha_to_20beta.sql): failed to open stream: No such file or directory in /web/Wicked.127/www.wickedpictures.com/htdocs/dotproject/install/do_install_db.php on line 132

Warning: filesize(): Stat failed for /web/Wicked.127/www.wickedpictures.com/htdocs/dotproject/db/upgrade_20alpha_to_20beta.sql (errno=2 - No such file or directory) in /web/Wicked.127/www.wickedpictures.com/htdocs/dotproject/install/do_install_db.php on line 132

Warning: fread(): supplied argument is not a valid stream resource in /web/Wicked.127/www.wickedpictures.com/htdocs/dotproject/install/do_install_db.php on line 132

There were 0 errors in 0 SQL statements
Applying data modifications

Fatal error: Call to a member function on a non-object in /web/Wicked.127/www.wickedpictures.com/htdocs/dotproject/includes/db_connect.php on line 132

[Karen]

Lodged in Mantis as Bug Report 597 - please follow status there and in the beta testers forum.

[ajdonnison]

Check mantis bug 597.

[avbitton]

Thanks. A patch was already posted which I applied and am now getting this:

Progress:

Applying database updates
There were 63 errors in 198 SQL statements
There were 0 errors in 1 SQL statements
Applying data modifications
ERROR: Table 'dotproject.projects' doesn't exist


Warning: Invalid argument supplied for foreach() in /web/Wicked.127/www.wickedpictures.com/htdocs/dotproject/db/upgrade_to_20beta.php on line 50

ERROR: Table 'dotproject.tasks' doesn't exist


Warning: Invalid argument supplied for foreach() in /web/Wicked.127/www.wickedpictures.com/htdocs/dotproject/db/upgrade_to_20beta.php on line 78

Converting users to contacts
ERROR: Table 'dotproject.users' doesn't exist


Warning: Invalid argument supplied for foreach() in /web/Wicked.127/www.wickedpictures.com/htdocs/dotproject/db/upgrade_contacts.php on line 9

Creating new Permissions objects
Converting admin user permissions to Administrator Role
Searching for add-on modules to add to new permissions
ERROR: Table 'dotproject.modules' doesn't exist


Warning: Invalid argument supplied for foreach() in /web/Wicked.127/www.wickedpictures.com/htdocs/dotproject/db/upgrade_permissions.php on line 168

Updating version information
Creating config


Database Installation Feedback: DB setup incomplete - the following errors occured:
Table 'dotproject.projects' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.modules' doesn't exist
Table 'dotproject.user_tasks' doesn't exist
Table 'dotproject.users' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.tasks' doesn't exist
Table 'dotproject.files' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.syskeys' doesn't exist
Table 'dotproject.syskeys' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.user_tasks' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.users' doesn't exist
Table 'dotproject.user_preferences' doesn't exist
Table 'dotproject.user_preferences' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.task_log' doesn't exist
Table 'dotproject.task_log' doesn't exist
Table 'dotproject.task_log' doesn't exist
Table 'dotproject.companies' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.tasks' doesn't exist
Table 'dotproject.tasks' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.files' doesn't exist
Table 'dotproject.files' doesn't exist
Table 'dotproject.sysvals' doesn't exist
Table 'dotproject.syskeys' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.events' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.projects' doesn't exist
Table 'dotproject.tasks' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.contacts' doesn't exist
Table 'dotproject.forum_watch' doesn't exist
Table 'dotproject.forum_watch' doesn't exist

[ajdonnison]

I think you've broken your install. Go back to your backups and try again.

[avbitton]

I've never used dotproject before. I just did a clean 1.02 install and then upgraded to 2 and used the new patch from Mantis. The installation finished and I can log in and make a project however I cannot add a task. The browser just hangs when I click 'new'. I'm looking for logging...

[Karen]

If you are aiming for 1.0.2 then use that and stop there.

2.0 is in beta test and is unstable, so you are going to have to take your chances. Having said that - if you have a new installation why not just install 2.0 - there is no requirement to update unless you have existing data. I think you may be better to wait at least for a few days until we get a chance to stablise things but if you really do want to proceed then at least get rid of the database that you have created already and start from a totally greenfields site.

You're very early in the beta process and you're not part of the control group unfortunately - please have a look at the beta announcement in that forum to see how we are planning on approach this testing phase.