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?

Errors for infuse / after Upload a Infusion

Asked Modified Viewed 2,279 times
C
Catzenjaeger
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions
asked
Senior Member

i get a error for a infuse.

i have upload my infusion and get in this moment a error.

Driver/PDOMySQL.php
/site/administration/index.php?aid=3b7c2ea7fd2f7cc3&pagenum=3
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ac_com_.fusion149L3_figure_settings' doesn't exist
Line: 106
6 minutes ago

i don't know what i have to do. Can anyone help?
0 replies

7 posts

F
Falk
F
Falk 131
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 11 questions
answered
Super Admin

Sounds like a classic error from wrong DB type, https://www.php-fusion.co.uk/forum/viewthread.php?thread_id=31997
0 replies
C
Catzenjaeger
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions
answered
Senior Member

not this is correct: ENGINE=MyISAM
i think is other problem. any idea?
0 replies
F
Falk
F
Falk 131
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 11 questions
answered
Super Admin

No it can be anything in the table creation that is not correct in the infusion.php.
0 replies
C
Catzenjaeger
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions
answered
Senior Member

Thanx for response.
Falk, i have check and check it again plus compare with other infusions and cant find a error

here the compete infusion.php.

curious - when i install the infusion i lost the error.
but i have seen in my database there is a other error what i cant find


<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright © 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: infusion.php
| Author: Khalid545
| URL: http://khalidb.co.cc/
| E-Mail: khalidd545@gmail.com
|
| Modification: Catzenjaeger
| URL: www.aliencollectors.com
| E-Mail: admin@aliencollectors.com
+--------------------------------------------------------+
| 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"); }

include "infusion_db.php";

$inf_title = $locale['INF_TITLE'];
$inf_description = $locale['INF_DESC'];
$inf_developer = "Khalid545";
$inf_email = "khalidd545@gmail.com";
$inf_weburl = "http://khalidb.co.cc/";

$inf_newtable[1] = DB_FIGURE_CATS." (
      figure_cat_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
      figure_cat_name varchar(100) NOT NULL DEFAULT '',
      figure_cat_description text NOT NULL,
      figure_cat_sorting varchar(50) NOT NULL DEFAULT 'download_title ASC',
      figure_cat_access tinyint(3) unsigned NOT NULL DEFAULT '0',
      figure_cat_parent mediumint(8) unsigned NOT NULL DEFAULT '0',
      figure_cat_items int(10) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (figure_cat_id)
   ) ENGINE=MyISAM;";
$inf_droptable[1] = DB_FIGURE_CATS;

$inf_newtable[2] = DB_FIGURE." (
      figure_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
      figure_title varchar(200) NOT NULL DEFAULT '',
      figure_submanufacturer varchar(200) NOT NULL DEFAULT '',
      figure_brand varchar(200) NOT NULL DEFAULT '',
      figure_series varchar(200) NOT NULL DEFAULT '',
      figure_variant varchar(200) NOT NULL DEFAULT '',
      figure_scale varchar(200) NOT NULL DEFAULT '',
      figure_weight varchar(200) NOT NULL DEFAULT '',
      figure_height varchar(200) NOT NULL DEFAULT '',
      figure_width varchar(200) NOT NULL DEFAULT '',
      figure_depth varchar(200) NOT NULL DEFAULT '',
      figure_material varchar(200) NOT NULL DEFAULT '',
      figure_packaging varchar(200) NOT NULL DEFAULT '',
      figure_retailprice varchar(200) NOT NULL DEFAULT '',
      figure_limitation varchar(200) NOT NULL DEFAULT '',
      figure_editionsize varchar(200) NOT NULL DEFAULT '',
      figure_artists varchar(200) NOT NULL DEFAULT '',
      figure_cat mediumint(8) unsigned NOT NULL DEFAULT '0',
      figure_description text NOT NULL,
      figure_url varchar(200) NOT NULL DEFAULT '',
      figure_file varchar(100) NOT NULL DEFAULT '',
      figure_image varchar(100) NOT NULL DEFAULT '',
      figure_name mediumint(8) unsigned NOT NULL DEFAULT '1',
      figure_filesize varchar(20) NOT NULL DEFAULT '',
      figure_datestamp int(10) unsigned NOT NULL DEFAULT '0',
      figure_author varchar(200) NOT NULL DEFAULT '',
      figure_country varchar(200) NOT NULL DEFAULT '',
      figure_manufacturer varchar(200) NOT NULL DEFAULT '',
      figure_pubdate varchar(200) NOT NULL DEFAULT '',
      figure_count int(10) unsigned NOT NULL DEFAULT '0',
      figure_allow_comments tinyint(1) unsigned NOT NULL DEFAULT '1',
      figure_allow_ratings tinyint(1) unsigned NOT NULL DEFAULT '1',
      KEY figure_datestamp (figure_datestamp),
      KEY figure_count (figure_count),
      PRIMARY KEY (figure_id)
   ) ENGINE=MyISAM;";
$inf_droptable[2] = DB_FIGURE;

$inf_newtable[3] = DB_FIGURE_SETTINGS." (
      figure_settings_name varchar(200) NOT NULL DEFAULT '',
      figure_settings_value text NOT NULL
   ) ENGINE=MyISAM;";
$inf_droptable[3] = DB_FIGURE_SETTINGS;

$inf_newtable[4] = DB_FIGURE_SUBMISSIONS." (
      submit_id mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
      submit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
      submit_datestamp INT(10) UNSIGNED DEFAULT '0' NOT NULL,
      submit_criteria TEXT NOT NULL,
      PRIMARY KEY (submit_id)
   ) ENGINE=MyISAM;";
$inf_droptable[4] = DB_FIGURE_SUBMISSIONS;

$inf_newtable[5] = DB_FIGURE_REPORTS." (
        report_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
        report_datestamp int(10) unsigned NOT NULL DEFAULT '0',
      report_name varchar(50) NOT NULL DEFAULT '1',
      report_ip varchar(20) NOT NULL DEFAULT '0.0.0.0',
      report_figure mediumint(8) unsigned NOT NULL DEFAULT '1',
        PRIMARY KEY (report_id)
    ) ENGINE=MyISAM;";
$inf_droptable[5] = DB_FIGURE_REPORTS;

$inf_insertdbrow[1] = DB_FIGURE_SETTINGS." VALUES ('figure_max_b','150000');";
$inf_insertdbrow[2] = DB_FIGURE_SETTINGS." VALUES ('figure_per_page','10');";
$inf_insertdbrow[3] = DB_FIGURE_SETTINGS." VALUES ('figure_types','.pdf,.doc,.html,.htm,.prc,.pdb,.zip,.rar');";
$inf_insertdbrow[4] = DB_FIGURE_SETTINGS." VALUES ('figure_submit','1');";
$inf_insertdbrow[5] = DB_FIGURE_SETTINGS." VALUES ('guestdownload','1');";
$inf_insertdbrow[6] = DB_FIGURE_SETTINGS." VALUES ('subcats','0');";
$inf_insertdbrow[7] = DB_FIGURE_SETTINGS." VALUES ('display','0');";
$inf_insertdbrow[8] = DB_FIGURE_SETTINGS." VALUES ('figure_per_line','2');";
$inf_insertdbrow[9] = DB_FIGURE_SETTINGS." VALUES ('social_sharing','1');";
$inf_insertdbrow[10] = DB_FIGURE_SETTINGS." VALUES ('related','1');";

$inf_altertable[1] = DB_FIGURE_CATS." ADD figure_cat_parent mediumint(8) unsigned NOT NULL DEFAULT '0'";
$inf_altertable[2] = DB_FIGURE." ADD figure_country varchar(200) NOT NULL DEFAULT ''";
$inf_altertable[3] = DB_FIGURE_CATS." ADD figure_cat_items int(10) unsigned NOT NULL DEFAULT '0'";

if (isset($_GET['defuse']) && isnum($_GET['defuse'])) {
   $result = dbquery("DELETE FROM ".DB_BCOMMENTS." WHERE comment_type='BO'");
   $result = dbquery("DELETE FROM ".DB_RATINGS." WHERE rating_type='B'");
}

$inf_sitelink[1] = array(
   "title" => $locale['INF_TITLE'],
   "url" => "figure.php",
   "visibility" => "0"
);

$inf_sitelink[2] = array(
   "title" => $locale['figure_521'],
   "url" => "submit.php",
   "visibility" => "101"
);

$inf_adminpanel[1] = array(
   "title" => $locale['INF_ADMIN'],
   "image" => "image.gif",
   "panel" => "figure_admin.php",
   "rights" => "BOL"
);
?>
Catzenjaeger attached the following file:
unbenannt_6.jpg [No information available / 92 Downloads]
0 replies
F
Falk
F
Falk 131
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 11 questions
answered
Super Admin

infusion_db.php also need inclusion in affected areas, sometimes devs miss that and it won´t find the tables.
For example, place in settings.php if it is missing. etc.
include "infusion_db.php";
0 replies
C
Catzenjaeger
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions
answered
Senior Member

you mean this file?

found it smile DB_PREFIX." missing here:

if (!defined("DB_FIGURE_REPORTS"wink) {
define("DB_FIGURE_REPORTS", DB_PREFIX."figure_reports"wink;
}

but what is the other problem (error in queue befor infuse!)
0 replies
C
Catzenjaeger
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions
answered
Senior Member

Quote

infusion_db.php also need inclusion in affected areas, sometimes devs miss that and it won´t find the tables.
For example, place in settings.php if it is missing. etc.
include "infusion_db.php";

- by Falk



hmn it is inside overall

require_once "../../../maincore.php";
require_once THEMES."templates/admin_header.php";
include "../infusion_db.php";
if (!checkrights("BOL") || !defined("iAUTH") || $_GET['aid'] != iAUTH) { redirect(BASEDIR."index.php"); }

i get
Driver/PDOMySQL.php
/site/administration/errors.php?aid=3b65e2208a499520
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ac_com_.fusion149L3_figure_settings' doesn't exist
Line: 106

Line 106: trigger_error($e->getMessage(), E_USER_ERROR);
just now
Edited by Catzenjaeger on 03-05-2016 10:50,
0 replies

Labels

None yet

Statistics

  • Views 0 views
  • Posts 7 posts
  • Votes 0 votes
  • Topic users 2 members

2 participants

F
F
Falk 131
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 11 questions
C
C
  • Senior Member, joined since
  • Contributed 408 posts on the community forums.
  • Started 137 threads in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet