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. Upgrading issues - 8
  5. v6 to v7 rc1 upgrade error

v6 to v7 rc1 upgrade error

Locked Asked Modified Viewed 3,752 times
Back to Forum Index Previous Topic Next Topic
Print
A
Arda
A
Arda 10
  • Member, joined since
  • Contributed 150 posts on the community forums.
  • Started 11 threads in the forums
  • Started this discussions
asked
Member

hi, ive got this error after i upload administration/upgrade.php to server at step 2

Code Download source
Can't DROP 'comment_smileys'; check that column/key existsUnknown column 'forum_posting' in '"prefixhere"forums'Duplicate column name 'forum_reply'Duplicate column name 'forum_attach'Duplicate column name 'forum_poll'Duplicate column name 'forum_vote'Duplicate column name 'thread_poll'Can't DROP 'post_subject'; check that column/key existsDuplicate column name 'article_draft'Duplicate column name 'news_draft'Duplicate column name 'sitebanner1'Duplicate column name 'sitebanner2'Unknown column 'attachments' in '"prefixhere"settings'Duplicate column name 'default_search'Duplicate column name 'exclude_left'Duplicate column name 'exclude_upper'Duplicate column name 'exclude_lower'Duplicate column name 'exclude_right'Duplicate column name 'enable_terms'Duplicate column name 'license_agreement'Duplicate column name 'license_lastupdate'Duplicate column name 'forum_ranks'Duplicate column name 'forum_edit_lock'Duplicate column name 'photo_watermark'Duplicate column name 'photo_watermark_save'Duplicate column name 'photo_watermark_image'Duplicate column name 'photo_watermark_text'Duplicate column name 'photo_watermark_text_color1'Duplicate column name 'photo_watermark_text_color2'Duplicate column name 'photo_watermark_text_color3'Duplicate column name 'userthemes'Duplicate column name 'newsperpage'Duplicate column name 'user_admin_password'Duplicate column name 'user_threads'


and after all steps done, i got this error at last seen users panel:
Code Download source
Notice: Use of undefined constant user_lastvisit - assumed 'user_lastvisit' in /home/pfusion/public_html/portakallikek/themes/templates/panels.php(75) : eval()'d code on line 6


and at forum threads list panel, number of replies is -1 at threads which has reply

what i'd done wrong? and how to fix these issues? i've already have my backups, i'm sure i followed guide
and further ideas will be appreciated
thanks,
0 replies

13 posts

E
Elactos
E
Elactos 10
Infusions & modifications for PHP-Fusion v7
http://www.redward.org
  • Member, joined since
  • Contributed 138 posts on the community forums.
  • Started 5 threads in the forums
answered
Member

Your forum thread list panel is for v6 and is therefore not working.
0 replies
A
Arda
A
Arda 10
  • Member, joined since
  • Contributed 150 posts on the community forums.
  • Started 11 threads in the forums
  • Started this discussions
answered
Member

all files are updated, so they're all replaced, so that's impossible :) and as you can see from 1st error , it's not only about forum threads list
Edited by Arda on 22-06-2008 20:43,
0 replies
M
Matonor
M
Impossible things are there to be made possible
  • Veteran Member, joined since
  • Contributed 1,022 posts on the community forums.
  • Started 3 threads in the forums
answered
Veteran Member

Did the column comment_smileys exist in you v6 database?
0 replies
A
Arda
A
Arda 10
  • Member, joined since
  • Contributed 150 posts on the community forums.
  • Started 11 threads in the forums
  • Started this discussions
answered
Member

no it didn't
Edited by Arda on 22-06-2008 20:48,
0 replies
A
afaaro
A
afaaro 10
  • Senior Member, joined since
  • Contributed 295 posts on the community forums.
  • Started 68 threads in the forums
answered
Senior Member

I have upgraded smoothly, worked fine.

Thanks to PHPFusion TEAM
0 replies
A
Arda
A
Arda 10
  • Member, joined since
  • Contributed 150 posts on the community forums.
  • Started 11 threads in the forums
  • Started this discussions
answered
Member

these are current tables:

Quote

# prefix_admin
# prefix_articles
# prefix_article_cats
# prefix_blacklist
# prefix_captcha
# prefix_comments
# prefix_custom_pages
# prefix_downloads
# prefix_download_cats
# prefix_faqs
# prefix_faq_cats
# prefix_flood_control
# prefix_forums
# prefix_forum_attachments
# prefix_infusions
# prefix_messages
# prefix_messages_options
# prefix_mod_db_category
# prefix_mod_db_mod
# prefix_news
# prefix_news_cats
# prefix_new_users
# prefix_online
# prefix_panels
# prefix_photos
# prefix_photo_albums
# prefix_polls
# prefix_poll_votes
# prefix_posts
# prefix_ratings
# prefix_seo_icerik
# prefix_settings
# prefix_shoutbox
# prefix_site_links
# prefix_submissions
# prefix_text_reklam
# prefix_threads
# prefix_thread_notify
# prefix_users
# prefix_user_groups
# prefix_weblinks
# prefix_weblink_cats
0 replies
M
Matonor
M
Impossible things are there to be made possible
  • Veteran Member, joined since
  • Contributed 1,022 posts on the community forums.
  • Started 3 threads in the forums
answered
Veteran Member

comment_smileys should exist. it is in the 6.01.15 setup structure. you either did some mod or missed one upgrade
0 replies
A
Arda
A
Arda 10
  • Member, joined since
  • Contributed 150 posts on the community forums.
  • Started 11 threads in the forums
  • Started this discussions
answered
Member

that's the weird part, it exists...

Quote

comment_smileys tinyint(1) unsigned NOT NULL default '1',

i will recheck the table..
are following errors connected with this ?
0 replies
A
afaaro
A
afaaro 10
  • Senior Member, joined since
  • Contributed 295 posts on the community forums.
  • Started 68 threads in the forums
answered
Senior Member

You should disable things thats not compatible with Version 7 before you upgrade as it mentioned to Readme
0 replies
A
Arda
A
Arda 10
  • Member, joined since
  • Contributed 150 posts on the community forums.
  • Started 11 threads in the forums
  • Started this discussions
answered
Member

Quote

afaaro wrote:
You should disable things thats not compatible with Version 7 before you upgrade as it mentioned to Readme


yea yea i know, i translated that stuff :) it's only standart installation, and the error is from a core table, not an external mod
0 replies
A
Arda
A
Arda 10
  • Member, joined since
  • Contributed 150 posts on the community forums.
  • Started 11 threads in the forums
  • Started this discussions
answered
Member

totally weird. i undid everything, and re-made the upgrade, now step 2 is clean, but this issue at step 4:

Quote

Duplicate column name 'forum_postcount'Duplicate column name 'forum_threadcount'Duplicate column name 'thread_lastpostid'Duplicate column name 'thread_postcount'


any ideas ?
Edited by Arda on 22-06-2008 21:35,
0 replies
B
Basti
B
Basti 10
[PHP-Fusion Crew Member & Admin from June 2008 - December 2010]

http://basti2web.de - Support Site for my infusions
  • Veteran Member, joined since
  • Contributed 1,099 posts on the community forums.
  • Started 32 threads in the forums
answered
Veteran Member

It means, that this columns are already there.

Can it be, that this is left from the update, which you did some minutes ago?
If there are no other error notices, it could be OK...

Compare your current database with the one of the setup.php of v7.
Maybe everything is ok now ;)
Edited by Basti on 22-06-2008 21:50,
0 replies
A
Arda
A
Arda 10
  • Member, joined since
  • Contributed 150 posts on the community forums.
  • Started 11 threads in the forums
  • Started this discussions
answered
Member

it's totally weird, now i got no errors, there absolutely was no difference between those ones i tried, this was a clone of the site, andit's always tried over same installation clone.. weird..

but i still have the second issue

how can i fix that?

edit: fixed, check here
Edited by Arda on 23-06-2008 14:38,
0 replies

Category Forum

Upgrading issues - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 13 posts
  • Votes 0 votes
  • Topic users 5 members

5 participants

M
M
Impossible things are there to be made possible
  • Veteran Member, joined since
  • Contributed 1,022 posts on the community forums.
  • Started 3 threads in the forums
A
A
afaaro 10
  • Senior Member, joined since
  • Contributed 295 posts on the community forums.
  • Started 68 threads in the forums
A
A
Arda 10
  • Member, joined since
  • Contributed 150 posts on the community forums.
  • Started 11 threads in the forums
  • Started this discussions
E
E
Elactos 10
Infusions & modifications for PHP-Fusion v7
http://www.redward.org
  • Member, joined since
  • Contributed 138 posts on the community forums.
  • Started 5 threads in the forums
B
B
Basti 10
[PHP-Fusion Crew Member & Admin from June 2008 - December 2010]

http://basti2web.de - Support Site for my infusions
  • Veteran Member, joined since
  • Contributed 1,099 posts on the community forums.
  • Started 32 threads in the forums

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet