Simple PHP/MySQL question

[dcmginc]

Hi,

I've been working on a forum that has a mod for Adsense Rev Share. After I got it installed everything loads fine, but when you go to update your adsense code in the profile you get the following error:

===========
Could not select default dateformat

DEBUG MODE

SQL Error : 1146 Table 'webhostb_phpbb1.phpbb_ad_user' doesn't exist

SELECT * FROM phpbb_ad_user WHERE user_id = 2

Line : 26
File : /home/webhostb/public_html/ad_profile.php
============

I'm not a pro at DBs but this looks like missing table(s). Anyone willing to help me solve this for NP$?

 

[axilant]

well it seems that the table is missing, look in phpMyAdmin and click on your database, and look for that table, if its missing. Try looking for the sql queries for it

They usally are named like db.sql or database.sql or something like that it could be in the readme file or something.

Well post back Ill help you out

 

[dcmginc]

Thanks for the reply!

Believe it or not the install file was useless and there are no .sql files to run through phpmyadmin. I know exactly what you're talking about and there just isn't any with this. I also went to the site that was listed for who created it and that seems to have been just as much of a waste. No one has bothered to answer the question on that forum either.

Is it possible that the table can be created without anything being imported into it or is that highly unlikely?

 

[dcmginc]

How about for real $$$$$... Anyone?

 

[Michau]

I guess the install did not go thru completely, it did not create the tabel which the script needs. Can you send me the files which make up this mod, maybe I will be able to extract the SQL for table cration from them. The SQL code must be there

 

[dcmginc]

Here you go Michau. See what I had to work with in the attached .zip file.

 

[Michau]

Ooops, apparently these files don't have any installation script. But I hacked the SQL queries which use this table and I created the structure from scratch Here you have the necessary code:

CREATE TABLE phpbb_ad_user
(
    user_id INTEGER PRIMARY KEY,
    ad_client_id CHAR(25) NOT NULL,
    ad_channel CHAR(25) NOT NULL
);

Run it and it should create the table you need. NP$ appreciated

BTW, the version number is 0.01, it gives me a suspicion that it would not work very well even if you create the table...

 

[dcmginc]

Ooops, apparently these files don't have any installation script. But I hacked the SQL queries which use this table and I created the structure from scratch Here you have the necessary code:

CREATE TABLE phpbb_ad_user
(
    user_id INTEGER PRIMARY KEY,
    ad_client_id CHAR(25) NOT NULL,
    ad_channel CHAR(25) NOT NULL
);

Run it and it should create the table you need. NP$ appreciated

BTW, the version number is 0.01, it gives me a suspicion that it would not work very well even if you create the table...

You da man! Thanks soooo much for that help. That's all it took and it works like a charm now.

 

[Michau]

You're most welcome :D