MySQL Problem [mysql-fetch-assoc()] | Forum | MemHT Portal

MemHT Portal is a Free PHP CMS and Blog

It permit the creation and the management online of websites with few and easy steps.
It's completely customizable, expandable and suitable for all needs.

Download MemHT 4 Stable version

Download MemHT 5 Beta version

Home > Forum > MemHT Portal > Problems and Errors > MySQL Problem [mysql-fetch-assoc()]

Forum

Home > MemHT Portal > Problems and Errors > MySQL Problem [mysql-fetch-assoc()]

Moderators: Moderators

MySQL Problem [mysql-fetch-assoc()]

Author

Text

siemek11
Just arrived

Posts: 3
Contributes: 3

Gender: _MALE_

Online: No

Version: 4.0.1
Country: Poland
Languages: English, Polish

Date: 29/01/2009 22:01
MySQL Problem [mysql-fetch-assoc()]

#post17820

Site url: http://download.mbluzino.pl/
MemHT version: 4.0.1
Hosting OS: Linux (2.6.24.5-grsec-xxxx-grs-ipv4-64)
PHP and MySQL versions: PHP:5.2.6, MySQL:5.0.67-community
Installed addons/scripts: none
Error/Problem:

Hi everyone!
I've got a problem with MySQL Database. As You can see on my website (www.download.mbluzino.pl) there is a short mysql error massage on a top of all webpages (Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mbluzino/public_html/download/inc/inc_database.php on line 81). It had become after I deleted localization table from database. Can everyone tell me how to fix it? I've tried to add localization table once again, but it didn't help. I've tried to delete and modify line 81 from inc_tadabase.php, it didn't solve my problem too. Smile

siemek11

mem
MemHT's Dad
Admin & Developer

Posts: 7243
Contributes: 4800

Gender: _MALE_

Online: No

Languages: English, Italiano, Македонски, Српски

Date: 30/01/2009 18:45
Re: MySQL Problem [mysql-fetch-assoc()]

#post17833

Why have you deleted it? :

Anyway, if you're talking about memht_iptocountry table, execute the following query in phpMyAdmin:

code

CREATE TABLE IF NOT EXISTS `memht_iptocountry` (

  `fromip` bigint(12) NOT NULL default '0',

  `toip` bigint(12) NOT NULL default '0',

  `ccode` char(2) NOT NULL default '',

  `cname` varchar(50) NOT NULL default ''

) ENGINE=MyISAM;

Follow me on twitter if you want to be updated on the MemHT 5 development.

siemek11
Just arrived

Posts: 3
Contributes: 3

Gender: _MALE_

Online: No

Version: 4.0.1
Country: Poland
Languages: English, Polish

Date: 30/01/2009 20:25 Re: MySQL Problem [mysql-fetch-assoc()]	#post17841
I deleted it becouse i don't need informations contained in this table. Thank you very much for your reply, this helped me, there's no longer mysql error!

mem
MemHT's Dad
Admin & Developer

Posts: 7243
Contributes: 4800

Gender: _MALE_

Online: No

Languages: English, Italiano, Македонски, Српски

Date: 31/01/2009 10:29 Re: MySQL Problem [mysql-fetch-assoc()]	#post17853
Never delete tables... NEVER! You might delete their CONTENT, but not the TABLE itself Follow me on twitter if you want to be updated on the MemHT 5 development.