Simple PHP/MySQL question

dcmginc · 09-30-2004, 05:49 PM

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:
????: NamePros.com http://www.namepros.com/programming/49800-simple-php-mysql-question.html

===========
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 · 09-30-2004, 06:09 PM

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 · 09-30-2004, 08:09 PM

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 · 10-01-2004, 08:53 AM

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

Michau · 10-01-2004, 09:26 AM

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 · 10-01-2004, 10:28 AM

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

Michau · 10-01-2004, 10:54 AM

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:

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

????: NamePros.com http://www.namepros.com/showthread.php?t=49800

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 · 10-01-2004, 12:29 PM

Originally Posted by 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:
????: NamePros.com http://www.namepros.com/showthread.php?t=49800

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 · 10-02-2004, 04:34 AM

You're most welcome

09-30-2004, 05:49 PM	THREAD STARTER #1 (permalink)
dcmginc NamePros Member Join Date: Apr 2004 Posts: 66	Simple PHP/MySQL question 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: ????: NamePros.com http://www.namepros.com/programming/49800-simple-php-mysql-question.html =========== 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$? __________________ :lala: The Voice of Maine Forum \| Irving Sucks

09-30-2004, 08:09 PM	THREAD STARTER #3 (permalink)
dcmginc NamePros Member Join Date: Apr 2004 Posts: 66	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? __________________ :lala: The Voice of Maine Forum \| Irving Sucks

10-01-2004, 08:53 AM	THREAD STARTER #4 (permalink)
dcmginc NamePros Member Join Date: Apr 2004 Posts: 66	How about for real $$$$$... Anyone? __________________ :lala: The Voice of Maine Forum \| Irving Sucks

10-01-2004, 09:26 AM	#5 (permalink)
Michau NamePros Regular Join Date: Sep 2004 Location: Poland Posts: 245	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 __________________ Dropcatcher.de - .de domain dropcatching!

10-01-2004, 10:28 AM	THREAD STARTER #6 (permalink)
dcmginc NamePros Member Join Date: Apr 2004 Posts: 66	Here you go Michau. See what I had to work with in the attached .zip file. __________________ :lala: The Voice of Maine Forum \| Irving Sucks Last edited by dcmginc; 10-01-2004 at 12:28 PM.

09-30-2004, 06:09 PM	#2 (permalink)
axilant Account Closed Join Date: May 2004 Location: /etc/passwd Posts: 2,178	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

10-01-2004, 10:54 AM	#7 (permalink)
Michau NamePros Regular Join Date: Sep 2004 Location: Poland Posts: 245	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: 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 ????: NamePros.com http://www.namepros.com/showthread.php?t=49800 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... __________________ Dropcatcher.de - .de domain dropcatching!

10-02-2004, 04:34 AM	#9 (permalink)
Michau NamePros Regular Join Date: Sep 2004 Location: Poland Posts: 245	You're most welcome __________________ Dropcatcher.de - .de domain dropcatching!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)