phpmyadmin sql question, Just some quick help is all i need. Options

[NovaArgon]

Hello


I'm trying to do this.

http://phpbb3.smika.net/kb/kb_show.php?id=3

I have the database setup I just need some help translating that link into English and getting an example of what it would look like when I put it into my sql area in phpmyadmin.

Here




I don't want to learn the in's and out's of phpmyadmin i'm just trying to get an example of what I need to type into that box to get it to submit.

Thanks for the help


p.s. if you are not willing to help me do you know of another website that might be willing to answer noob questions on phpmyadmin?

[Brian Chandler]

The instructions say -- run this SQL command:

INSERT INTO `phpbb_lastrss_autopost`
(`name`, `url`, `next_check`, `next_check_after`, `destination_id`, `enabled`)
VALUES
('name', 'http://feed.url', 0, 12, 2, 1);

So this SQL command is what you need to paste into the "Run SQL" window in phpmyadmin.

It's hard to see what you need to have explained: you may not want to become an SQL guru, but you do need to understand at least the basics of how a database works. Otherwise you shouldn't really trust yourself to look after it.

[NovaArgon]

Thanks for the reply. I thought I had to add into that bit of code before posting it but when I do i get errors.
Its a mod for phpbb forums and the mod has not been released so its a use at your own risk thing.
My host installed it for me and said I just need to do this to plug in the info that I want the mod to use.
It posts rss feeds onto my forums. I just need to use phpmyadmin to tell it what rss feeds to post.
I'll try my lock on the phpbb forum again.
Thanks again for the help



EDIT ok here is the error i'm getting

CODE

Error

SQL query:

INSERT INTO `phpbb_lastrss_autopost` (
`name` ,
`url` ,
`next_check` ,
`next_check_after` ,
`destination_id` ,
`enabled`
)
VALUES (
'Game Reviews', 'http://rss.gamespot.com/misc/rss/gamespot_updates_reviews.xml', 0, 1, 4, 1

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

When I type this into my sql

CODE

INSERT INTO `phpbb_lastrss_autopost`
(`name`, `url`, `next_check`, `next_check_after`, `destination_id`, `enabled`)
VALUES
('Game Reviews', 'http://rss.gamespot.com/misc/rss/gamespot_updates_all_games.xml', 0, 1, '4', 1;

This post has been edited by NovaArgon: Feb 11 2009, 07:07 PM

[Brian Chandler]

CODE

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

When I type this into my sql

CODE

INSERT INTO `phpbb_lastrss_autopost`
(`name`, `url`, `next_check`, `next_check_after`, `destination_id`, `enabled`)
VALUES
('Game Reviews', 'http://rss.gamespot.com/misc/rss/gamespot_updates_all_games.xml', 0, 1, '4', 1;

MYSQL error messages are rather cryptic -- but there's a fairly obvious mismatched bracket: you have

VALUES ( ... with no )

HTH