| Topic Archived |
View previous topic :: View next topic |
| Author |
Message |
mafa Supporter


Offline Joined: Jan 30, 2006 Posts: 32 Location: Submerged
|
Posted: Fri Jun 15, 2007 6:35 am Post subject: Unknown column 'u.user_skype' in 'field list' |
|
Everything is fine upon a new install until I import cms_users via the database, then this when user try read a PM:
A database error has occurred
The webmaster has been notified of the error
| Code:: |
includes/db/db.php
* CMS Warning line 75: On /index.php?name=Private_Messages&folder=outbox&mode=read&p=4 While executing query "SELECT u.username AS username_1, u.user_id AS user_id_1, u2.username AS username_2, u2.user_id AS user_id_2, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_skype, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_avatar, pm.*, pmt.privmsgs_text FROM cms_bbprivmsgs pm, cms_bbprivmsgs_text pmt, cms_users u, cms_users u2 WHERE pm.privmsgs_id = 4 AND pmt.privmsgs_text_id = pm.privmsgs_id AND pm.privmsgs_from_userid = 2 AND ( pm.privmsgs_type = 1 OR pm.privmsgs_type = 5 ) AND u.user_id = pm.privmsgs_from_userid AND u2.user_id = pm.privmsgs_to_userid" the following error occured: Unknown column 'u.user_skype' in 'field list' In: /homepages//modules/Private_Messages/read.php on line: 67 |
I tried searching, but no real answers. Also I've tried reinsatlling (twice) but keep getting the same error.
Any help appreciated...
_________________ Sounds like a subdural hematoma to me...
mafa's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) CMS Version 9.1.2.1 PHP Version 5.0.4 MySQL Version 4.1.20 Build Date Mar 29 2006
|
|
| Back to top |
|
 |
sarah Debugger


Offline Joined: Mar 25, 2005 Posts: 2130
|
Posted: Fri Jun 15, 2007 7:18 am Post subject: Re: Another PM |
|
| Quote:: |
| until I import cms_users via the database |
What?
No, it won't work unless you use the installer to convert it.
_________________ Diagon Alley - Top Design
sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1
|
|
| Back to top |
|
 |
mafa Supporter


Offline Joined: Jan 30, 2006 Posts: 32 Location: Submerged
|
Posted: Fri Jun 15, 2007 8:37 am Post subject: Re: Another PM |
|
| sarah wrote: |
| No, it won't work unless you use the installer to convert it. |
Ok ta, I'll search the forums on that! This is new territory for me. Is it to do with "Load new module from CVS" or is there a download for a converter?
Had loads of trouble with this version, last on was beginner friendly imo. I conquered cm_bbattachments_desc & get_smilies errors (one way or another) but this PM business has stumped me.
_________________ Sounds like a subdural hematoma to me...
mafa's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) CMS Version 9.1.2.1 PHP Version 5.0.4 MySQL Version 4.1.20 Build Date Mar 29 2006
|
|
| Back to top |
|
 |
sarah Debugger


Offline Joined: Mar 25, 2005 Posts: 2130
|
Posted: Fri Jun 15, 2007 8:51 am Post subject: Re: Another PM |
|
Just upload the files and run the installer.
_________________ Diagon Alley - Top Design
sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1
|
|
| Back to top |
|
 |
mafa Supporter


Offline Joined: Jan 30, 2006 Posts: 32 Location: Submerged
|
Posted: Fri Jun 15, 2007 10:09 am Post subject: Re: Another PM |
|
Thanks for your help sarah, but I'm still stuck, think i'm doing something fundamentally wrong here.
This is what I've done so far:
1) Backed up my old 9.0.6.1 DB from admin control panel.
2) Clean install of Dragonfly 9.1.2.1 with new DB.
3) Imported forums, using Import SQL File from admin control panel
4) Done the same with users, but getting this PM problem.
I tried running the installer but it says:
You already have Dragonfly 9.1.2.1 installed.
I've tried searching more & a lot of links here seem to be broken from this sites recent revamp.
Sorry to be a pain...
_________________ Sounds like a subdural hematoma to me...
mafa's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) CMS Version 9.1.2.1 PHP Version 5.0.4 MySQL Version 4.1.20 Build Date Mar 29 2006
|
|
| Back to top |
|
 |
Eestlane I18N / L10N Lead Dev


Offline Joined: Apr 06, 2005 Posts: 1404 Location: Estonia
|
Posted: Fri Jun 15, 2007 12:13 pm Post subject: Re: Another PM |
|
Do it like that:
1) Back up old 9.0.6.1 via phpmyAdmin or Dragonfly administration->Dataabse
2) Upload all 9.1.2.1 files to your current 9.0.6.1 site, this overwrites old files.
Go to yoursite.php/install.php and add all the data your 9.0.6.1 site used.
Finish the installation and it's done.
Eestlane's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/2.0.63/5.0.67/5.2.8/9.2.1
|
|
| Back to top |
|
 |
mafa Supporter


Offline Joined: Jan 30, 2006 Posts: 32 Location: Submerged
|
Posted: Fri Jun 15, 2007 12:40 pm Post subject: Re: Another PM |
|
| Eestlane wrote: |
Go to yoursite.php/install.php and add all the data your 9.0.6.1 site used.
|
The database on my server I backed up my 9.0.6.1 from no longer exists, it is now a load of zips in my documents.
I've installed 9.1.2.1 on a new database (which is MySQL 5 whereas the previous was MySQL 4, could that be a problem?)
How would I add all the data as you say before I install?
Can't I just upload an amended table structure for cms_users edited in notepad (like I've been trying) using 9.1.2.1 parameters?
_________________ Sounds like a subdural hematoma to me...
mafa's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) CMS Version 9.1.2.1 PHP Version 5.0.4 MySQL Version 4.1.20 Build Date Mar 29 2006
|
|
| Back to top |
|
 |
sarah Debugger


Offline Joined: Mar 25, 2005 Posts: 2130
|
Posted: Fri Jun 15, 2007 7:13 pm Post subject: Re: Another PM |
|
| Quote:: |
| Imported forums, using Import SQL File from admin control panel |
Do this, but do it before you run the installer, not after. Also, import all of the data from 9.0.6.1 not just the forum data.
_________________ Diagon Alley - Top Design
sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1
|
|
| Back to top |
|
 |
mafa Supporter


Offline Joined: Jan 30, 2006 Posts: 32 Location: Submerged
|
Posted: Fri Jun 15, 2007 8:08 pm Post subject: Re: Another PM |
|
| sarah wrote: |
| Quote:: |
| Imported forums, using Import SQL File from admin control panel |
Do this, but do it before you run the installer, not after. Also, import all of the data from 9.0.6.1 not just the forum data. |
Aaarrghh another fresh install it is then, not sure how to import data as you say before Dragonfly is setup, but I'll be back!
It's taken me weeks to get this far to reopening my site! bb_attachments_desc required some serious cut n pasting in notepad & changing the extension to .sql to get that to work. As for admin get_smilies - works today....
Why does everything else work except PM? The member list is back, 40 members, I can't get them to re-register....
_________________ Sounds like a subdural hematoma to me...
mafa's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) CMS Version 9.1.2.1 PHP Version 5.0.4 MySQL Version 4.1.20 Build Date Mar 29 2006
|
|
| Back to top |
|
 |
sarah Debugger


Offline Joined: Mar 25, 2005 Posts: 2130
|
Posted: Fri Jun 15, 2007 8:18 pm Post subject: Re: Another PM |
|
I think you are overcomplicating this. Take your 9.0.6.1 database, upload the 9.1.2.1 files and run the installer. It converts the data to the 9.1.2.1 structure.
| Quote:: |
| Why does everything else work except PM? |
I think you might find that it doesn't, and that was simply the first problem you discovered. There are many data changes from 9.0.6.1 -> 9.1.2.1
_________________ Diagon Alley - Top Design
sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1
|
|
| Back to top |
|
 |
mafa Supporter


Offline Joined: Jan 30, 2006 Posts: 32 Location: Submerged
|
Posted: Mon Jun 18, 2007 7:58 am Post subject: Re: Another PM |
|
I uploaded a fresh 9.1.2.1 to another site & put my current DB info in the install setup & ran it, hey presto it sorted the DB out & the PM's now work. I didn't have to touch my site
Suppose that's one way of doing it!
Thanks sarah for your guidance
_________________ Sounds like a subdural hematoma to me...
mafa's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) CMS Version 9.1.2.1 PHP Version 5.0.4 MySQL Version 4.1.20 Build Date Mar 29 2006
|
|
| Back to top |
|
 |
sarah Debugger


Offline Joined: Mar 25, 2005 Posts: 2130
|
Posted: Mon Jun 18, 2007 8:07 am Post subject: Re: Another PM |
|
| Quote:: |
| I think you might find that it doesn't, and that was simply the first problem you discovered. There are many data changes from 9.0.6.1 -> 9.1.2.1 |
There will most likely be other problems with that in the future. How's coppermine working? Why not just run the installer and upgrade the data?
_________________ Diagon Alley - Top Design
sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1
|
|
| Back to top |
|
 |
mafa Supporter


Offline Joined: Jan 30, 2006 Posts: 32 Location: Submerged
|
Posted: Mon Jun 18, 2007 9:05 am Post subject: Re: Another PM |
|
| sarah wrote: |
| How's coppermine working? |
Everything seems ok, no errors yet! I didn't have it enabled last version so users have not used it yet.I've uploaded pics & it seems fine (fingers crossed).
| sarah wrote: |
| Why not just run the installer and upgrade the data? |
Well thats what I was unsure how to do. I uploaded install dir & install.php again but it kept telling me "dragonfly already installed" etc..
What's the correct procedure to re-run the installer?
_________________ Sounds like a subdural hematoma to me...
mafa's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) CMS Version 9.1.2.1 PHP Version 5.0.4 MySQL Version 4.1.20 Build Date Mar 29 2006
|
|
| Back to top |
|
 |
sarah Debugger


Offline Joined: Mar 25, 2005 Posts: 2130
|
Posted: Mon Jun 18, 2007 9:41 am Post subject: Re: Another PM |
|
To recap:
You uploaded a 9.0.6.1 database. Then you uploaded the 9.1.2.1 files. You tried to run the installer and it told you 9.1.2.1 was already installed? What am I missing?
| Code:: |
SELECT cfg_value
FROM cms_config_custom
WHERE cfg_name = 'global'
AND cfg_field = 'Version_Num'; |
If you run that in phpMyAdmin what is the result?
_________________ Diagon Alley - Top Design
sarah's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Linux/1.3.37/4.1.21-standard/4.4.4/9.1.1
|
|
| Back to top |
|
 |
DJ Maze Developer


Offline Joined: Apr 19, 2004 Posts: 5683 Location: http://tinyurl.com/5z8dmv
|
Posted: Mon Jun 18, 2007 10:43 am Post subject: Re: Another PM |
|
I've fixed the topic title, since "Another PM" is really just to useless.
Mafa, next time think about that before you post it or your topic will end up in the rule breakers forum.
DJ Maze's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS) Fedora 15 / 2.2.22 / 5.5.20 / 5.3.10 / CVS
|
|
| Back to top |
|
 |
|
|