phpbb and Mysql !Error!

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785

phpbb and Mysql !Error!

Postby CyberIDentity » Thu Oct 28, 2004 10:33 pm

I am the ultra newb, currently reading SQL for dummies, its helping.

I need some definate answers on a few questions i hope someone can help me.

My enviroment is

Windows 2k server, SP4
latest PHP installer
Latest My SQL installer
latest Phpbb package
Personally Hosted

I have tried searching through the phpbb and Mysql forums but have not found this specific error.

The default database to my understanding Mysql creates is called

ibdata1

====

This is the output from the Mysql --console when running for the first time.

====
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
041029 7:57:10 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
041029 7:57:11 InnoDB: Log file .\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
041029 7:57:12 InnoDB: Log file .\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
041029 7:57:22 InnoDB: Started
C:\mysql\bin\mysqld.exe: ready for connections.
Version: '4.0.21-debug' socket: '' port: 3306 Source distribution

=====

From the above i determined that the database was created, am i wrong?

=====

The install page of Phpbb has no problem with this as far as i can see however when i enter the required data into the fields and click install i am presented with the following error.

An error has occurred during installation
An error occurred trying to update the database
Can't create/write to file '.\ibdata1\phpbb_auth_access.frm' (Errcode: 2)

I have visited the IRC channel for Phpbb and was told that Error 2 is folder/file not found, which leads me to ask the question, is it saying that it cannot access tables in ibdata1, or is a dir ibdata1 that it cannot access.

I have set everything up regarding permissions for folder access.

Thats the problem, as of now :) I am standing by this post until i get this problem fixed, PM to get my attention.

Thanks

CyberIDentity
CyberIDentity
Registered User
 
Posts: 1
Joined: Thu Oct 28, 2004 9:46 pm

Return to 2.0.x Support Forum

Who is online

Users browsing this forum: Yahoo [Bot] and 13 guests