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?
  1. Home
  2. Discussion Forum
  3. PHPFusion 8 Support
  4. Installation Issues - 8
  5. Missing tables and Upgrade window

Missing tables and Upgrade window

Asked Modified Viewed 1,826 times
Back to Forum Index Previous Topic Next Topic
Print
V
Vlammie
V
  • Newbie, joined since
  • Contributed 9 posts on the community forums.
  • Started 1 thread in the forums
  • Started this discussions
asked
Newbie

Hello

I am upgrading form version 6.19 to version 7.0. Most parts seem to work. However I have two issues left.
1) I am missing some tabels. amdg is te name of my site. The following tables seem to be missing: amdg.fusion_bbcodes, amdg.fusion_smileys, amdg.fusion_captcha, amdg.fusion_user_fields. May be there are more tables missing. When I did the upgrade proces i got errors, but the process was complete.
2) After upgrade 7.00.00 i wanted to upgrade to 7.00.01. Followed the procedure, but if i hit the upgrade button I get an almost empty page. It only say's "Table 'amdg.fusion_smileys' doesn't exist", May be I have to repair the tables issue before this will work.

Thanks for your help

Vlammie
0 replies

2 posts

V
Vlammie
V
  • Newbie, joined since
  • Contributed 9 posts on the community forums.
  • Started 1 thread in the forums
  • Started this discussions
answered
Newbie

One issue solved by an old trick I found here (posted by myself) :-)

Took the table generation code from the upgrade.php file. Put this in a a created custom page and hit the preview button. This generated the tables. Warnings are gone now. This is how the code looks like.

Code Download source
<?php
$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix.”smileys");
      $result = dbquery("CREATE TABLE ".$db_prefix.”smileys (
      smiley_id MEDIUMINT(8) unsigned NOT NULL AUTO_INCREMENT,
      smiley_code VARCHAR(50) NOT NULL,
      smiley_image VARCHAR(100) NOT NULL,
      smiley_text VARCHAR(100) NOT NULL,
      PRIMARY KEY (smiley_id)
      ) ENGINE=MyISAM;");
?>


Had to change TYPE to ENGINE by the way.

The other issue isn't solved yet
Edited by helmuth on 02-02-2015 11:44,
0 replies
F
Falk
F
Falk 148
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

:G
0 replies

Category Forum

Installation Issues - 8

Labels

None yet

Statistics

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

2 participants

F
F
Falk 148
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
V
V
  • Newbie, joined since
  • Contributed 9 posts on the community forums.
  • Started 1 thread in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet