Home Private Messages Search
CPG Dragonfly™ CMS stopsoftwarepatents.eu petition banner
Toggle Content
 
Forums ⇒ DragonflyCMS ⇒ Problems AFTER Install/Upgrade :: Archives ⇒ Unknown column 'u.user_skype' in 'field list' :: Archived


Unknown column 'u.user_skype' in 'field list' :: Archived
Issues that happen after DragonflyCMS upgrade/install.
DO NOT post module installation issues here!

Go to page 1, 2  Next
Post new topic    Revive this topic    Printer Friendly Page     Forum Index ⇒  Problems AFTER Install/Upgrade

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

Offline Offline
Joined: Jan 30, 2006
Posts: 32
Location: Submerged
PostPosted: 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
View user's profile
sarah
Debugger
Debugger

Offline Offline
Joined: Mar 25, 2005
Posts: 2130

PostPosted: 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
View user's profile Send e-mail Visit poster's website
mafa
Supporter
Supporter

Offline Offline
Joined: Jan 30, 2006
Posts: 32
Location: Submerged
PostPosted: 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
View user's profile
sarah
Debugger
Debugger

Offline Offline
Joined: Mar 25, 2005
Posts: 2130

PostPosted: 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
View user's profile Send e-mail Visit poster's website
mafa
Supporter
Supporter

Offline Offline
Joined: Jan 30, 2006
Posts: 32
Location: Submerged
PostPosted: 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
View user's profile
Eestlane
I18N / L10N Lead Dev
I18N / L10N Lead Dev

Offline Offline
Joined: Apr 06, 2005
Posts: 1404
Location: Estonia
PostPosted: 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
View user's profile Send e-mail Visit poster's website
mafa
Supporter
Supporter

Offline Offline
Joined: Jan 30, 2006
Posts: 32
Location: Submerged
PostPosted: 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
View user's profile
sarah
Debugger
Debugger

Offline Offline
Joined: Mar 25, 2005
Posts: 2130

PostPosted: 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
View user's profile Send e-mail Visit poster's website
mafa
Supporter
Supporter

Offline Offline
Joined: Jan 30, 2006
Posts: 32
Location: Submerged
PostPosted: 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....

Very sad

_________________
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
View user's profile
sarah
Debugger
Debugger

Offline Offline
Joined: Mar 25, 2005
Posts: 2130

PostPosted: 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
View user's profile Send e-mail Visit poster's website
mafa
Supporter
Supporter

Offline Offline
Joined: Jan 30, 2006
Posts: 32
Location: Submerged
PostPosted: 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 Big grin

Suppose that's one way of doing it!

Thanks sarah for your guidance Rose

_________________
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
View user's profile
sarah
Debugger
Debugger

Offline Offline
Joined: Mar 25, 2005
Posts: 2130

PostPosted: 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
View user's profile Send e-mail Visit poster's website
mafa
Supporter
Supporter

Offline Offline
Joined: Jan 30, 2006
Posts: 32
Location: Submerged
PostPosted: 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
View user's profile
sarah
Debugger
Debugger

Offline Offline
Joined: Mar 25, 2005
Posts: 2130

PostPosted: 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
View user's profile Send e-mail Visit poster's website
DJ Maze
Developer
Developer

Offline Offline
Joined: Apr 19, 2004
Posts: 5683
Location: http://tinyurl.com/5z8dmv
PostPosted: 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
View user's profile Visit poster's website Yahoo Messenger Photo Gallery
Display posts from previous:   
Post new topic    Revive this topic    Printer Friendly Page    Forum Index ⇒  Problems AFTER Install/Upgrade
Page 1 of 2
All times are GMT
Go to page 1, 2  Next

Archive Revive
Username:
This is an archived topic - your reply will not be appended here.
Instead, a new topic will be generated in the active forum.
The new topic will provide a reference link to this archived topic.
 
   Toggle Content User Info

Welcome Anonymous

Nickname
Password
(Register)

   Toggle Content Last CVS commits
· Fixed .ico Expires header.
· Removed domain name from cookies so subdomains wont access them anymore.
· CSS and JS, case insensitives.
· CSS and JS, send correct HTTP 1.1 headers and fixed issues where themes and...
· Further security class improvements.
· 301 redirects on LEO changes
· Option to force 3xx http status codes
· Validate googlebot.com and google.com crawlers.
· CCBot
· Rss with etag and atom.

read more...

   Toggle Content Community

Support for DragonflyCMS in a other languages:

Deutsch
Español

   Toggle Content X-links
UltraEdit Browse Happy logo Firefox MySQL PostgreSQL Valid CSS! Valid XHTML 1.0! Unicode Encoded Badge NukeBiz Resources Raven DragonflyCMS Dedicated Now InsideSupport Lampe Berger

You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
Interactive software released under GNU GPL, Code Credits, Privacy Policy