[your mom]

Right I know I have no connection to the database, just wondering how to fix it....

[leV]

When I try to enter a new ad into the list, it does not show up.

I want to put all my ads I currently use with Tsunami's plugin into the SQL list before I install the plugin, so I havn't installed this yet onto my servers, is that required? Would that fix my issue?

Thank you!

[sbghannibal]

Originally Posted by your mom Right I know I have no connection to the database, just wondering how to fix it....

mysql works normally at localhost this means you need to allow the ip from you server in the database to access it from the Internet

[your mom]

Got it working. My provider changed the ip of the box the gameserver sits on. I whitelisted it & now we are all good.

[strontiumdog]

Originally Posted by leV When I try to enter a new ad into the list, it does not show up. I want to put all my ads I currently use with Tsunami's plugin into the SQL list before I install the plugin, so I havn't installed this yet onto my servers, is that required? Would that fix my issue? Thank you!

There is a known bug that I will have fixed in the next version.
It happens when you add and then delete an ad, leaving a gap in the sequence.

One simple fix is to use the arrows on the right to move the ads or go into the database and fix the id numbers so they are in sequence.

[leV]

There are no ads in there :/ I deleted all the "test" ads you put in, and now nothing new goes into the database.

http://thecouchonline.net/ads/ads.php

[SuperShadow]

@lev,
If you have access to the database through PhpMyAdmin, you could put one entry directly into the database. That would probably get you working again. I don't think Dog coded for an empty table.

Your other option is to redo the original install on the database part. Delete all put one entry and just edit that remaining one to say what you wish. You should then be able to add the rest of the ads you want in there.

[leV]

I reuploaded the .sql, and deleted all of the test ad's but two of them, then tried adding a new one, but it didn't show :/ Doesn't seem to be working quite right..and I know I have all the info correct. I know a decent amount about PHP/sql (not like an expert or whatever...but I have experience) with it. Strange though, dog's permamute addon worked just fine!

[Kenny Loggins]

Can you post an example of the ad you are trying to add?

Anything with "" in it?

[leV]

{GREEN} - If the team's are absolutely horrid, type '{LIGHTGREEN}scramble{GREEN}' :)

I tried it without the apostrophe, no luck.