v6.01.13 to v7 SQL issues
Asked Modified Viewed 3,156 times
asked
Well I was doing a test for moving the current PFusion site I have up, and it gives me this message when trying to insert the posts or users into the new database for pFusion v7 RC2:
I even manually went in and created the forums and such by hand when the forums gave me that error. But I dunno what to do about users, threads, or posts :(
Quote
MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1
I even manually went in and created the forums and such by hand when the forums gave me that error. But I dunno what to do about users, threads, or posts :(
googlebot
googlebot 10
Visit the new home of the merge between Hacking Vs. Security and Security Override!
My copyright removal has been switched over from HvS to SecurityOverride.
My copyright removal has been switched over from HvS to SecurityOverride.
- Senior Member, joined since
- Contributed 638 posts on the community forums.
- Started 28 threads in the forums
Try upgrading again, but this time, after you restore your v6.01.13 database and files, upgrade to v6.01.15 first. Then upgrade to the RC's.
answered
I was actually trying to do a fresh install of v7 in another location then copy the needed SQL from the old site to the test site.
googlebot
googlebot 10
Visit the new home of the merge between Hacking Vs. Security and Security Override!
My copyright removal has been switched over from HvS to SecurityOverride.
My copyright removal has been switched over from HvS to SecurityOverride.
- Senior Member, joined since
- Contributed 638 posts on the community forums.
- Started 28 threads in the forums
Quote
sobe wrote:
I was actually trying to do a fresh install of v7 in another location then copy the needed SQL from the old site to the test site.
Oh, well did you upgrade your v6 database and then restore that database?
answered
No.. lol, its a fresh v7 database install.
Here are the steps I took:
-Install pFusion v7 fresh in a new directory
-Backup needed(users, forums, posts, threads, faq, downloads) SQL from v6 pFusion database #1
-Open phpMyAdmin for v7 pFusion Database and copy and paste the SQL INSERT commands into database #2(v7 pFusion)
There is no upgrading of databases, that is what I'm trying to point out. Would that be something I need to do to get it to convert to a new format of SQL listing if that is what it is. If so I can backup the older pFusion site then upgrade I suppose.
Here are the steps I took:
-Install pFusion v7 fresh in a new directory
-Backup needed(users, forums, posts, threads, faq, downloads) SQL from v6 pFusion database #1
-Open phpMyAdmin for v7 pFusion Database and copy and paste the SQL INSERT commands into database #2(v7 pFusion)
There is no upgrading of databases, that is what I'm trying to point out. Would that be something I need to do to get it to convert to a new format of SQL listing if that is what it is. If so I can backup the older pFusion site then upgrade I suppose.
Falk
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
• 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
I wunder if un-updated value of autoincrement would cause that.
Its a hot tip tho, set autoincrement to match post count.
Its a hot tip tho, set autoincrement to match post count.
answered
I'm sorry, but could you elaborate on that a bit more. Set autoincrement in phpMyAdmin for the tables I am wanting to insert into?
googlebot
googlebot 10
Visit the new home of the merge between Hacking Vs. Security and Security Override!
My copyright removal has been switched over from HvS to SecurityOverride.
My copyright removal has been switched over from HvS to SecurityOverride.
- Senior Member, joined since
- Contributed 638 posts on the community forums.
- Started 28 threads in the forums
Quote
sobe wrote:
Open phpMyAdmin for v7 pFusion Database and copy and paste the SQL INSERT commands into database #2(v7 pFusion)
There is no upgrading of databases, that is what I'm trying to point out. Would that be something I need to do to get it to convert to a new format of SQL listing if that is what it is. If so I can backup the older pFusion site then upgrade I suppose.
What you need to do is look in the v7 RC2 package. There should be a folder that is named something like /upgrade v6 to v7/ - go into that and you will find upgrade.php - put that in the /administration folder and visit it on yoursite.com/administration/upgrade.php and do the steps. Now (regardless of whether or not you have errors on the site currently) go to admin panel -> system admin -> db backup and back up your database. Then run the SQL query on the v7 database.
It's smart to disable all infusions before you backup the v7 database.
answered
Alright I uploaded all the v7 files, then set the config to direct to a duplicate v6 database. I then uploaded the upgrade.php, yet... When trying to access that through admincp, I get this:
grrrr, lol.
Quote
Warning: main(../subheader.php) [function.main]: failed to open stream: No such file or directory in /homepages/30/d141948114/htdocs/hosted/test/pfusion2/administration/upgrade.php on line 20
Fatal error: main() [function.require]: Failed opening required '../subheader.php' (include_path='.:/usr/lib/php') in /homepages/30/d141948114/htdocs/hosted/test/pfusion2/administration/upgrade.php on line 20
grrrr, lol.
googlebot
googlebot 10
Visit the new home of the merge between Hacking Vs. Security and Security Override!
My copyright removal has been switched over from HvS to SecurityOverride.
My copyright removal has been switched over from HvS to SecurityOverride.
- Senior Member, joined since
- Contributed 638 posts on the community forums.
- Started 28 threads in the forums
Quote
sobe wrote:
Alright I uploaded all the v7 files, then set the config to direct to a duplicate v6 database. I then uploaded the upgrade.php, yet... When trying to access that through admincp, I get this:Quote
Warning: main(../subheader.php) [function.main]: failed to open stream: No such file or directory in /homepages/30/d141948114/htdocs/hosted/test/pfusion2/administration/upgrade.php on line 20
Fatal error: main() [function.require]: Failed opening required '../subheader.php' (include_path='.:/usr/lib/php') in /homepages/30/d141948114/htdocs/hosted/test/pfusion2/administration/upgrade.php on line 20
grrrr, lol.
It was intended to be used when you are still running v6. Here's how you can fix it:
Delete the following lines:
Code Download source
require_once "../subheader.php";
require_once "../side_left.php";
and also delete these lines:
Code Download source
require_once "../side_right.php";
require_once "../footer.php";
You get the idea.. If the code isn't right, just delete those require_once's.
Then go to /administration/upgrade.php and although the page will be plain (without the theme), it should do the job correctly.
muscapaul
muscapaul 10
Paul
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
- Veteran Member, joined since
- Contributed 1,075 posts on the community forums.
- Started 8 threads in the forums
I guess you have to replace the first two lines with and the second two lines with or the page still won't load.
Quote
require_once THEMES."templates/admin_header_mce.php";
Quote
require_once THEMES."templates/footer.php";
answered
Ah ok, after taking out that and the require admin navigation I added "require_once THEMES."templates/admin_header.php";" and was able to upgrade :)
Thank you very much googlebot and everyone that helped.
Thank you very much googlebot and everyone that helped.
answered
Ah and I found a better way to go about a fresh v7 site, lol. Have 1 "going live" v7 and one v6 upgraded to v7 so you can copy the new sql inserts to the fresh v7 XD
Makes sense to me at least :P All is well ^^ Thank you very much everyone.
Makes sense to me at least :P All is well ^^ Thank you very much everyone.
googlebot
googlebot 10
Visit the new home of the merge between Hacking Vs. Security and Security Override!
My copyright removal has been switched over from HvS to SecurityOverride.
My copyright removal has been switched over from HvS to SecurityOverride.
- Senior Member, joined since
- Contributed 638 posts on the community forums.
- Started 28 threads in the forums
Quote
sobe wrote:
Ah and I found a better way to go about a fresh v7 site, lol. Have 1 "going live" v7 and one v6 upgraded to v7 so you can copy the new sql inserts to the fresh v7 XD
Makes sense to me at least :P All is well ^^ Thank you very much everyone.
Well, as long as it works.. ;)
Category Forum
Upgrading issues - 8Labels
None yet
Statistics
- Views 0 views
- Posts 13 posts
- Votes 0 votes
- Topic users 4 members
4 participants
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
• 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
muscapaul 10
Paul
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
Time flies like an arrow, fruit flies like banana (Groucho Marx)
Sites: Diptera.info (site owner); Online-Keys.net (site owner); Sciomyzidae.info (site co-owner); muscapaul.com (defunct; site owner)
- Veteran Member, joined since
- Contributed 1,075 posts on the community forums.
- Started 8 threads in the forums
sobe 10
- Member, joined since
- Contributed 56 posts on the community forums.
- Started 12 threads in the forums
- Started this discussions
googlebot 10
Visit the new home of the merge between Hacking Vs. Security and Security Override!
My copyright removal has been switched over from HvS to SecurityOverride.
My copyright removal has been switched over from HvS to SecurityOverride.
- Senior Member, joined since
- Contributed 638 posts on the community forums.
- Started 28 threads in the forums
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions