I am having a big problem... please can someone make sure Thoul gets this. I would normally try to get help on another board he frequents- phpBB Hacks - but as you can see in the text below, that board is down for me too...

Thoul-

I hope you are the same person that is on the phpBB Hacks board...

I am having a BIG problem. I can't tell if some of it is due to the phpbbHacks board, or me...

Anyway, details below- I am copying you on some info I have sent to others...

Thanks for any help you can provide with either the SQL query, or explaining how to fix the problem I am having with the phpBB Hacks Board...


***********************************************
I am trying to install Random Custom logo mod on my wife's board on ca_aphrodite template.
I am running into some errors, with some dead ends. I have a problem with SQL, but I also seem to have more problems.


The SQL update file won't run-
When I run "rc_logo_install.php"
I get:
"ERROR!"

When I try to manually run the SQL in Myphp SQL query:

Code: Select all

CREATE TABLE phpbb_logos (id MEDIUMINT (8) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, page INT (11) DEFAULT '0', image VARCHAR (255) DEFAULT '0', cat_id MEDIUMINT(8) UNSIGNED, PRIMARY KEY(id), UNIQUE(id), INDEX(id))

I get:

Code: Select all

CREATE TABLE phpbb_logos(
id MEDIUMINT( 8 ) UNSIGNED DEFAULT  '0' NOT NULL AUTO_INCREMENT ,
page INT( 11 ) DEFAULT  '0',
image VARCHAR( 255 ) DEFAULT  '0',
cat_id MEDIUMINT( 8 ) UNSIGNED,
PRIMARY KEY ( id ) ,
UNIQUE (
id
),
INDEX ( id )
)

MySQL said:

#1067 - Invalid default value for 'id'

I can't even get onto phpBB Hacks page... I have auto login set, password as well (in my browser), and when I try to sign on there, I get:

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1016 Can't open file: 'phpbb_users.MYI'. (errno: 145)

SELECT u.* FROM phpbb_users u, phpbb_sessions_keys k WHERE u.user_id = 35538 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = '652a385530c16f2f7754a7272b5a9579'

Line : 88
File : sessions.php

Is that problem with THEIR board? It looks as though their database has somehow not remembered my sign in/on info...

I don't know what to do now...

Please help or tell me where to go either on this forum or somewhere else where I can get some of this analyzed...

To fix your SQL query, use this query instead:

Code: Select all

CREATE TABLE phpbb_logos (id MEDIUMINT (8) UNSIGNED NOT NULL AUTO_INCREMENT, page INT (11) DEFAULT '0', image VARCHAR (255) DEFAULT '0', cat_id MEDIUMINT(8) UNSIGNED, PRIMARY KEY(id));

The problem at phpBBHacks is indeed an issue with that board. The database server was down for a brief time on Tuesday evening, and that error has been appearing on the forums ever since the DB server was restored. Something damaged the database, probably during the server crash. Due to the nature of the damage, this error, or some variation of it, is going to appear for everybody.

Thanks so much for the SQL ---

About the phpBB Hacks board... what should I do? Is there anything I can do on my end? Are they in the process of fixing this?

There's nothing you can do - it's entirely on their end. The admin of phpBBHacks, Patrick, is the only one that can fix this. I'm sure he'll get it back to normal as soon as he possibly can. The rest of us will just have to wait until then. I would recommend checking the site again in a few days.

Thanks for the explanation... at least it keeps me from wondering in the dark.


I rely sometimes pretty heavily on folks like you and Spinebuster, others on the site as well. It is a damn confusing world to jump into if you don't have a computer programming language background...

I am having some troubles installing Random Custom Logo on my wife's site... she (her site) is using a different template/style, and I wanred her ahead of time that it might cause some problems for me with some mods... at least I had enough background and experience to know that THAT might happen...

Anyway- I really need to ask some folks (you included- but I don't want to imply I expect you to help "now") what might be the problems with the mod and that template (ca_aphrodite)...

I have done what I could figure on my own to this point, checking all of the upload files, and mod code edits for things that might cause problems...

I have an IQ of well over 145, and some coding things really elude me... most of the time I feel the answer is probably right in front of me but out of my grasp...

Most of the time...common sense/logic will prevail when coding php.

Many of the functions are continually called out (hence the include statements at the top of php files) throughout a phpbb forum.

Also I have found many times it's the order in which an instruction set is carried out that will make or break a script.

But I'm a newb as well as rely on people like Thoul to shine a little light on the subject.....or the sun for that matter.

You're doing pretty good, both of you. I'm glad you're taking the time to explore on your own and then ask questions when you need the help. That's the best way to learn, IMO. There are too many people out there that want everything handed to them on a silver platter.