I downloaded and installed PhPay yesterday, and I think I've found (and solved in my case) a bug.
From line 464, it reads:
db_query2("CREATE TABLE it_itgr (
ID INT(8) NOT NULL AUTO_INCREMENT,
itemID INT(8) NULL,
itemgrID INT(8) NULL,
PRIMARY KEY (ID),
)") or db_die2();
The problem is that trailing comma in the "PRIMARY KEY (ID)" clause - the create command fails because of it.
During the DB initialization, it failed with a syntax error which didn't bother me at the time, but when problems occurred - it boiled down to that line.
Now I've created the table, so I'm going forward with my phPay quest. :)
Cheers from Croatia
W.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, everyone!
I downloaded and installed PhPay yesterday, and I think I've found (and solved in my case) a bug.
From line 464, it reads:
db_query2("CREATE TABLE it_itgr (
ID INT(8) NOT NULL AUTO_INCREMENT,
itemID INT(8) NULL,
itemgrID INT(8) NULL,
PRIMARY KEY (ID),
)") or db_die2();
The problem is that trailing comma in the "PRIMARY KEY (ID)" clause - the create command fails because of it.
During the DB initialization, it failed with a syntax error which didn't bother me at the time, but when problems occurred - it boiled down to that line.
Now I've created the table, so I'm going forward with my phPay quest. :)
Cheers from Croatia
W.