Hi, I have a godaddy site that I have created from a PHP Fusion layout. I have most everything working and this is my first site so its a learning process. However, I have been trying to add in the existing shoutbox and its giving me and error.
Here is the error.
Table 'techitch_phpf1.DB_SHOUTBOX' doesn't existYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5 No messages have been posted.
Now keep in mind that i tried creating DB called shoutbox and then changed the values in the infusion_db.php file to this....
<?php /*-------------------------------------------------------+ | PHPFusion Content Management System | Copyright � 2002 - 2011 Nick Jones | http://www.php-fusion.co.uk/ +--------------------------------------------------------+ | Filename: infusion_db.php | Author: MarcusG +--------------------------------------------------------+ | This program is released as free software under the | Affero GPL license. You can redistribute it and/or | modify it under the terms of this license which you | can read by viewing the included agpl.txt or online | at www.gnu.org/licenses/agpl.html. Removal of this | copyright header is strictly prohibited without | written permission from the original author(s). +--------------------------------------------------------*/ if (!defined("IN_FUSION")) { die("Access Denied"); }
if (!defined("shoutbox")) { define("shoutbox", DB_PREFIX."shoutbox"); } ?>
I thought that it might help but now in totally screwed because I don't remember what the default values were. And since they seem to be unique to each database file I feel i may have to call it quits and just not use it. So this is my final cry lol.
The only database file i have currently is calle techitch_phpf1 which was created by the install of the PHP fusion template.
So there is my story. Any help would be greatly appreciated.
Need help?, Having trouble? • View our Documentation for Guides, Standards and Functions • Name and Organize your Topics and Content correctly in the corresponding Forums for best support results • Attaching Log Files and Screenshots when reporting issues will help • Provide with an URL to live example if one exists • Please read the How to Report an Error post • Please read and comply with the Code of Conduct
Very helpful thank you. You don't happen to have the default values handy?
Merged on Mar 06 2014 at 03:10:17: Okay so i found a work around and I got the old values in place. ( I made a sub domain and added the template there) now when i searched for the TYPE value if found the the value was already set to ENGINE. Any other posts that might help me? Sorry to bug abd thanks again.
The issue was that you cannot connect to the infusion, and the thread resolved regarding to this technical bit. Do you still have problem or is it fixed?
I still have problems. I still get the error I posted. I tired changing from ENGINE to TYPE and still the same issue. the setting was right all a long. So I am wondering its just a code errors somewhere.
the only database I have is a mySQL labeled techitch_phpf1 the error has an added bit to this same label and that's techitch_phpf1.phpf_shoutbox.
The the shout box infusion DB file now looks like this.
<?php /*-------------------------------------------------------+ | PHPFusion Content Management System | Copyright � 2002 - 2011 Nick Jones | http://www.php-fusion.co.uk/ +--------------------------------------------------------+ | Filename: infusion_db.php | Author: MarcusG +--------------------------------------------------------+ | This program is released as free software under the | Affero GPL license. You can redistribute it and/or | modify it under the terms of this license which you | can read by viewing the included agpl.txt or online | at www.gnu.org/licenses/agpl.html. Removal of this | copyright header is strictly prohibited without | written permission from the original author(s). +--------------------------------------------------------*/ if (!defined("IN_FUSION")) { die("Access Denied"); }
if (!defined("DB_SHOUTBOX")) { define("DB_SHOUTBOX", DB_PREFIX."shoutbox"); } ?>
And I have the line for the infusion.php file set to ENGINE
Need help?, Having trouble? • View our Documentation for Guides, Standards and Functions • Name and Organize your Topics and Content correctly in the corresponding Forums for best support results • Attaching Log Files and Screenshots when reporting issues will help • Provide with an URL to live example if one exists • Please read the How to Report an Error post • Please read and comply with the Code of Conduct