Database

[bowyersden]

Is MySQl fine for the database? I am trying a new install and locking at step 1. I am copying the DB name and DB user name right out of the web server info on my control panel. I re did the password several times to make sure it's the same.

I can't get past it. I would think once is me, but I have triple checked everything. Any ideas. Running on a windows platform

[nebenaube]

yes it's fine... are you using odbc or is the server listening on the standard port? What are you using for a webserver? is mysql support compiled in /enabled? How about php?

[bowyersden]

I got that fixed, Now it wants to create tables, but has an error.

Code: Select all

Errors while creating initial phpwcms tables. Solve it manually:

How is there errors? I did not change anything.

[nebenaube]

When you created the database and user did you grant the user all access to the database? Do you have query logs from the database?

[bowyersden]

The bold ones are the only ones selected. Do I need to select them all? I did not have to do this for a message board for phpbb3.

Privilege name
grant
lock tables
drop
create routine
create temporary tables
update
create
alter
index
execute
select
alter routine
show view
references
insert
delete
create view

[bowyersden]

Do you have query logs from the database?

Nube here, not sure where they are, if they are there.

[bowyersden]

I check them all and got.

Fine! All initial phpwcms tables were created or still exists.

So it seems to work now.

[bowyersden]

Crashed out on step 3 on setup to a white page.

That was after e-mail settings. I did not setup a php.ini file yet. Is that why is crashed?

EDIT

I used a comma.

[nebenaube]

You're getting there. Your database user will also need to have the alter table privilege. Yes, you will need the php.ini. If you are setting this up on a development box (running on localhost, not on the net) You should turn the error logging on in PHP.ini It will help to track down any problems you are having.