text-link-ads.com problem with wordpress

Hello when i try too active plugin for http://www.text-link-ads.com/ in wordpress i got that error:


WordPress database error: [Table 'tests_ss.wp_tla_data' doesn't exist]
TRUNCATE `wp_tla_data`

WordPress database error: [Table 'tests_ss.wp_tla_data' doesn't exist]
SELECT * FROM wp_tla_data WHERE post_id > 0

I think it dont have rights too create new mysql table? If anyone know how to fix it pls help.

Thanks.

 

1. Which version of Wordpress are you running?
2. Do you have access to the DataBase?
3. Which version of the TLA plugin are you using?

 

1: 2.2
2: Yes i have access to database, all other work normal.
3: The newest version of TLA plugin, i did just download it when i register (today)

 

Don't you have to have a .txt file also uploaded too with your individual and unique number in it?

Something like it anyway... from memory.

 

did you de-activating and re-activating the plugin? Sometimes it's just a hickup..

 

yes i tried evrything, it seems that it dont want too creat database ... i know how too create database in phpmyadmin but i need right code. It dont accept directly PHP tags:

$sql = "CREATE TABLE `$this->tlaDataTable` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`post_id` bigint(20) unsigned NOT NULL default '0',
`url` TEXT NOT NULL,
`text` TEXT NOT NULL,
`before_text` TEXT NOT NULL,
`after_text` TEXT NOT NULL,
`rss_text` TEXT NOT NULL,
`rss_before_text` TEXT NOT NULL,
`rss_after_text` TEXT NOT NULL,
`rss_prefix` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `post_id` (`post_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;";

dbDelta($sql);

$sql = "CREATE TABLE `$this->rssMapTable` (
`post_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`advertisement` TEXT NOT NULL ,
PRIMARY KEY ( `post_id` )
) TYPE = MYISAM ;";

 

I had the same problem with TLA and their widget. I removed it, then a few days later I got an email that said they sold an ad on my site so I had to get the code back up.

I had to use the phpexec widget, and add the php code from TLA. I also had to upload the xml file to my root directory. It works well.

this will only work on self hosted WP sites. I doubt wordpress.com will let you use phpexec widget.

 

I also having similar issue.. anyone can help?

 

Hi,

I had the same problem you guys ran into. This is what I did to get it to work...

1. Open the tla_links.php file find the following code and copy the Sql String portion:
CREATE TABLE `$this->tlaDataTable` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`post_id` bigint(20) unsigned NOT NULL default '0',
`url` TEXT NOT NULL,
`text` TEXT NOT NULL,
`before_text` TEXT NOT NULL,
`after_text` TEXT NOT NULL,
`rss_text` TEXT NOT NULL,
`rss_before_text` TEXT NOT NULL,
`rss_after_text` TEXT NOT NULL,
`rss_prefix` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `post_id` (`post_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;";

Replace the $this-> with wp_ and ALSO rename tlaDataTable to tla_data. The TLA code expects that string. (I think the major problem is that the name the tla script calls is completely different than the name it uses to create the database table.)

2. In PHPAdmin copy the above modified SQL code and execute it - Done!
3. Copy the second SQL create table command from the tla_links.php file, remember to replace the $this-> with wp_ then repeat step 2.
4. Back in WP admin - activate plugin and you're done.

Good luck!

 

Thanks dezignergal! This solution really works...