Help - Search - Members - Calendar
Full Version: phpmyadmin sql question
HTMLHelp Forums > Programming > Databases
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

IPB Image


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;
Brian Chandler
QUOTE(NovaArgon @ Feb 12 2009, 08:46 AM) *

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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.