|
Mods Issue(error)please help
|
| Revive |
Posted on 09-04-2012 14:32
|
Newbie
Posts: 3
Joined: 08/04/2012
|
Hi
For the first I like to appologize for my english its not my natural lang.
Also I like to say that I am running my first site,so I am not some kind of PRO.
Issue:
1.I decided to move my site from free webhosting to profi.(different provider)
2.Since I vas unable to transport mysql DB thanks to unicodes(latin2 to utf8),I maked a fresh new instalation of php and connected with fresh new MYSQL DB.Everything ok in DB and also on my new site.Until...
3.I need to instal some mods like custom contact for example,so I install it in php,everything green and ok,like on my old site.But when I go to mod trough modifications and click on it shows me that table in mysql doesnt exists.So mod didnt create the tabs.
And I get bug report in reports.
4.here it is:
Table 'd20470_ally.fusion524nB_contact_settings' doesn't exist
Bug report telling me that I have to go in maincore php on line 233 but I have no idea what changes I have to made to make this work.
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given Line: 233
227 function dbrows($query) {
228 $result = @mysql_num_rows($query);
229 return $result;
230 }
231
232 function dbarray($query) {
233 $result = @mysql_fetch_assoc($query);
234 if (!$result) {
235 echo mysql_error();
236 return false;
237 } else {
238 return $result;
239 }
240 }
241
242 function dbarraynum($query) {
5.I already three times completly reinstaled php fusion and mysql,tryed change stuff in best I can do and still nothing.So I diceded to make one more new fresh install and wait if someone can help me.
6.Its wired that on free webhosting it runs automatickly without any prob.
And on profi hosting it giving me a hard time.
7.Also I noticed that modification included in php shoutbox runs absolutely ok when I install it and normaly make tables in mysql DB.
But when I download some mod its imposible to make it run.I tryed more mods and still same fault.I can create tab manualy in mysql but that is not solution for me,since I doesnt understand properly some atributes there and I cant create all tabs in all mods I need.
Any help with this issue will be a great.I am stuck on it 3 days already.
Many Thanks.... With My Kindest Regards Revive |
| |
|
|
| JoiNNN |
Posted on 09-04-2012 14:37
|
Admin
Posts: 294
Joined: 05/02/2011
|
Open infusion.php from the folder of the infusion you are trying to infuse, search for TYPE=MyISAM and replace with ENGINE=MyISAM |
| |
|
|
| Revive |
Posted on 09-04-2012 21:00
|
Newbie
Posts: 3
Joined: 08/04/2012
|
Hi
OMG its working just fine 
I really appreciate your help man.
It was been so easy...and on other forums they was given me so hard instructions.
I must look like stupid but I really dont know much about programing like that.
SOLVED BY ADMIN JoiNNN !Perfect work.Thank you.
My Kindest Regards  |
| |
|
|
| skpacman |
Posted on 09-04-2012 22:08
|
Member
Posts: 103
Joined: 23/04/2009
|
Just for reference: MySQL Bug Report #17501
In MySQL starting at v4.1 they depreciated and ultimately removed the TYPE identifier for table editing and creation.
MySQL's rationale behind it seems a bit dodgy, but I suppose it's for ease of implementation in later releases.
Unfortunately, a large number of the current PHP-Fusion addons use TYPE for table creations for infusions instead of ENGINE due to the date they were created.
I've made it a habit to check infusion.php for TYPE before installing in order to avoid those table errors.
BTW - Welcome to the PHP-Fusion community, Revive
|
| |
|
|
| PolarFox |
Posted on 09-04-2012 22:37
|
Admin
Posts: 1480
Joined: 26/08/2008
|
Unfortunately, a large number of the current PHP-Fusion addons use TYPE for table because the PF 7 example package contain this identifier.
|
| |
|
|
| skpacman |
Posted on 09-04-2012 23:52
|
Member
Posts: 103
Joined: 23/04/2009
|
I'll correct that on the download on my site. Should add a note in the documentation in that package that mentions the difference between TYPE and ENGINE
|
| |
|
