1
aeks222
error help..
  • 2005/12/1 16:51

  • aeks222

  • Just popping in

  • Posts: 13

  • Since: 2005/11/1


i cant login to my site and when i try to register a new username it says this

mySQL query error: UPDATE xoops_session SET member_name='',member_id='0',member_group='2',login_type='0', sess_updated='1133456247', in_forum='', in_topic='', location='Reg,,10' WHERE sess_id='5d2b19766f0fcf504c18f3e142d21cab'

mySQL error: Unknown column 'member_name' in 'field list'
mySQL error code:
Date: Thursday 01st of December 2005 11:57:27 AM


how can i solve it?

2
Bender
Re: error help..
  • 2005/12/1 19:54

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


What version of XOOPS is that?

I haven´t found that member_name column in the sql structure of either XOOPS 2.0.x nor 2.2.x.
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

3
highlander
Re: error help..
  • 2005/12/1 21:45

  • highlander

  • Not too shy to talk

  • Posts: 151

  • Since: 2004/12/5


Indeed Bender,

my session table looks very different aswell.

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
-- 
-- 
Hostlocalhost
-- Generation TimeDec 012005 at 10:46 PM
-- Server version4.0.25
-- PHP Version4.3.11
-- 
-- 
Database: `xxxxxx`
-- 

-- --------------------------------------------------------

-- 
-- 
Table structure for table `xoops_session`
-- 

CREATE TABLE `xoops_session` (
  `
sess_idvarchar(32NOT NULL default '',
  `
sess_updatedint(10unsigned NOT NULL default '0',
  `
sess_ipvarchar(15NOT NULL default '',
  `
sess_datatext NOT NULL,
  
PRIMARY KEY  (`sess_id`),
  
KEY `updated` (`sess_updated`)
TYPE=MyISAM;


I am guessing that your XOOPS version does not have a table like your SQL command either. This is the reason your getting this nasty message. As you can see from my export the session table has the following columns : sees_id, sess_updated, sess_ip and sess_data.

I tried your site but could not quite read enough to try and register

greetings Highlander
So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
http://www.AnimalPedigree.com

Login

Who's Online

160 user(s) are online (46 user(s) are browsing Support Forums)


Members: 0


Guests: 160


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Oct 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits