Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

Shoutbox DB error

Asked Modified Viewed 2,857 times
T
TeChNiCaL ItCh
T
  • Newbie, joined since
  • Contributed 9 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
asked
Newbie

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 &#65533; 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.

Thanks!
Itch
0 replies

9 posts

T
TeChNiCaL ItCh
T
  • Newbie, joined since
  • Contributed 9 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
answered
Newbie

Yes now it works like a charm :) :) :) :)
0 replies
C
Craig
C
Craig 14
  • Fusioneer, joined since
  • Contributed 4,462 posts on the community forums.
  • Started 212 threads in the forums
answered
Fusioneer

Was that it? sorted?
0 replies
T
TeChNiCaL ItCh
T
  • Newbie, joined since
  • Contributed 9 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
answered
Newbie

FML SMH :smacks face:

Thank you... lol

Itch
0 replies
C
Craig
C
Craig 14
  • Fusioneer, joined since
  • Contributed 4,462 posts on the community forums.
  • Started 212 threads in the forums
answered
Fusioneer

You need to defuse it and infuse again.
0 replies
T
TeChNiCaL ItCh
T
  • Newbie, joined since
  • Contributed 9 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
answered
Newbie

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 &#65533; 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

Oh and I am using godaddy
0 replies
C
Chan
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,842 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
answered
Super Admin

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?
0 replies
T
TeChNiCaL ItCh
T
  • Newbie, joined since
  • Contributed 9 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
answered
Newbie

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.

Itch
Edited by TeChNiCaL ItCh on 06-03-2014 05:10,
0 replies
F
Falk
F
Falk 146
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

(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
  • Super Admin, joined since
  • Contributed 6,201 posts on the community forums.
  • Started 639 threads in the forums
  • Answered 12 questions
answered
Super Admin

Hello,
please check this post here : http://www.php-fusion.co.uk/forum/viewthread.php?thread_id=31997

You need to revert your changes and restore original files and then follow the steps in the post.
0 replies
T
TeChNiCaL ItCh
T
  • Newbie, joined since
  • Contributed 9 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
answered
Newbie

OH and to add I was getting the error from the start. before i tried editing the DB file.
0 replies

Category Forum

Panels and Infusions

Labels

None yet

Statistics

  • Views 0 views
  • Posts 9 posts
  • Votes 0 votes
  • Topic users 4 members

4 participants

F
F
Falk 146
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

(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
  • Super Admin, joined since
  • Contributed 6,201 posts on the community forums.
  • Started 639 threads in the forums
  • Answered 12 questions
C
C
Craig 14
  • Fusioneer, joined since
  • Contributed 4,462 posts on the community forums.
  • Started 212 threads in the forums
C
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,842 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
T
T
  • Newbie, joined since
  • Contributed 9 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet