Hello, first off I'm newb to MySQL and PHP, I don't know half the things I'm doing.
As the topic says, I'm trying to set up an imageboard with apache don't worry I'm not coding or anything, just trying to get an existing imageboard script called futallaby to work. Can be found here: http://www.1chan.net/futallaby/index_old.html
I installed Apache and MySQL, decompressed the script in htdocs. Followed the instructions and edited the config.php half-blind, but I must've did something wrong cause when I upload a picture to test the script it gives the same SQL error over and over. These are the parts I edited in config.php
define(SQLLOG, 'table'); //Table used by image board
define(SQLUSER, 'root'); //MySQL user
define(SQLPASS, 'board'); //MySQL user's password
define(SQLDB, 'board'); //Database used by image board
define(ADMIN_PASS, ''); //Janitor password- (When I set a password it gives another sql error; Access denied for user 'root'@'localhost' (using password: YES))
And the error when I upload a picture;
Database error, check SQL settings
show tables like 'table'
tableCreating table!
\ncreate table table (primary key(no), no int not null auto_increment, now text, name text, email text, sub text, com text, host text, pwd text, ext text, w int, h int, tim text, time int, md5 text, fsize int, root timestamp, resto int)
Unable to create table!
select max(no) from table
Critical SQL problem!
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\board\imgboard.php on line 399
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\board\imgboard.php on line 401
select no,ext,tim from table where no<=-500
Critical SQL problem!
select time from table where com='No Text' and host='sonny' and no>-20
Critical SQL problem!
.
.
.
I can see the problem is SQL related :o . So what am I doing wrong here ?