SQL question

[paruhd0x]

I'm editing my SQL database so I can add the color names feature on my msg board... I'm stuck though on one of the instructions I am supposed to follow.

Here is what I am supposed to do:

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_custom_color', '250');

Here is a pic of what I have to work with... (I'm using phpmyadmin through cpanel)

SQL question

Any help is appreciated!

 

[aircooled]

Yikes! beyond my skill set 🙂

Try here. if that's not the answer, then you may want to post your question over there.

 

[paruhd0x]

Originally posted by: aircooled
Yikes! beyond my skill set 🙂

Try here. if that's not the answer, then you may want to post your question over there.

Yeah, I've been searching like a mad man through www.phpbbhacks.com and www.phpbb.com forums. No luck yet.

 

[ISAslot]

Have you tried running the sql statement from the "Run SQL query/queries on database " box on the home db page?

 

[AzNmAnJLH]

I hate sql.....

 

[BCYL]

The screen you provided is editing the table attributes... You cannot run the SQL Command from there...

 

[dawks]

I think allow_custom_color should go in "Length/Values*" column, and the number '250' should go in 'Values' column ?

 

[paruhd0x]

Originally posted by: ISAslot
Have you tried running the sql statement from the "Run SQL query/queries on database " box on the home db page?

I got an invalid syntax error... not sure what I'm supposed to run in it exactly...

 

[paruhd0x]

Originally posted by: BCYL
The screen you provided is editing the table attributes... You cannot run the SQL Command from there...

Can you direct me to where I am supposed to be? =)

 

[jonmullen]

Originally posted by: paruhd0x

Originally posted by: ISAslot
Have you tried running the sql statement from the "Run SQL query/queries on database " box on the home db page?

I got an invalid syntax error... not sure what I'm supposed to run in it exactly...

There should be a place that lets you run an SQL statement aginst the db. Try this and post the results.

"SELECT * FROM phpbb_config"

 

[paruhd0x]

I think I figured it out. We'll see in 10 minutes when I finish editing the php on my boards.

 

[paruhd0x]

Failed to update general configuration for ('allow_custom_color', '250')

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'allow_custom_color', '250')' WHERE config_name = '('allow_custom_color', '25' at line 2

UPDATE phpbb_config SET config_value = '('allow_custom_color', '250')' WHERE config_name = '('allow_custom_color', '250')'

Line : 62
File : /home/paradox/public_html/bb/admin/admin_board.php

Uh oh. Now i'm stuck 🙁

 

[paruhd0x]

Originally posted by: jonmullen

Originally posted by: paruhd0x

Originally posted by: ISAslot
Have you tried running the sql statement from the "Run SQL query/queries on database " box on the home db page?

I got an invalid syntax error... not sure what I'm supposed to run in it exactly...

There should be a place that lets you run an SQL statement aginst the db. Try this and post the results.

"SELECT * FROM phpbb_config"

I ran that and got this:

Database paradox_xmb3 - Table phpbb_config running on localhost

Error

SQL-query :

"SELECT * FROM phpbb_config"

MySQL said:

You have an error in your SQL syntax near '"SELECT * FROM phpbb_config"' at line 1

 

[BCYL]

Originally posted by: paruhd0x

Failed to update general configuration for ('allow_custom_color', '250')

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'allow_custom_color', '250')' WHERE config_name = '('allow_custom_color', '25' at line 2

UPDATE phpbb_config SET config_value = '('allow_custom_color', '250')' WHERE config_name = '('allow_custom_color', '250')'

Line : 62
File : /home/paradox/public_html/bb/admin/admin_board.php

Uh oh. Now i'm stuck 🙁

You need to run this:

UPDATE phpbb_config SET config_value = '250' WHERE config_name = 'allow_custom_color'

 

[BCYL]

Originally posted by: paruhd0x

Originally posted by: jonmullen

Originally posted by: paruhd0x

Originally posted by: ISAslot
Have you tried running the sql statement from the "Run SQL query/queries on database " box on the home db page?

I got an invalid syntax error... not sure what I'm supposed to run in it exactly...

There should be a place that lets you run an SQL statement aginst the db. Try this and post the results.

"SELECT * FROM phpbb_config"

I ran that and got this:

Database paradox_xmb3 - Table phpbb_config running on localhost

Error

SQL-query :

"SELECT * FROM phpbb_config"

MySQL said:

You have an error in your SQL syntax near '"SELECT * FROM phpbb_config"' at line 1

You do not need the double-quotes in the select statement... so just:

select * from phpbb_config

is fine...

EDIT: Seems like you dont know anything about SQL... maybe you should try doing some reading on it before using it...

 

[paruhd0x]

Oh well, I gave up and did a SQL database restore and phpbb restore. I'll try again later.

Of course I don't know any SQL, I'm just modding my phpbb... they tell you step by step what to do. Normally I don't have any problems.