Outpost Universe Forums

Off Topic => Computers & Programming General => Topic started by: spirit1flyer on December 02, 2005, 04:46:33 PM

Title: Good Old Problems With Php
Post by: spirit1flyer on December 02, 2005, 04:46:33 PM
I don't know if anyone will be able to help me fix this on my forum. so if you can Please hlep me :P

I am trying to install an arcade for my members but I have run into a problem.
Code: [Select]
mySQL query error: UPDATE inv_sessions SET member_name='spirit1flyer',member_id='1',member_group='4',in_forum='0',in_topic='0',in_game='0|',login_type='',running_time='1133563140',location='idx,,' WHERE id='a6a47453ffd562a48e14e9f4c205664a'

mySQL error: Unknown column 'in_game' in 'field list'
mySQL error code: 
Date: Friday 02nd of December 2005 02:39:00 PM

I don't know how to fix this   :blush:   <_<  
can anyone take a shot at it?

spirit
Title: Good Old Problems With Php
Post by: Eddy-B on December 02, 2005, 05:28:03 PM
Quote
mySQL error: Unknown column 'in_game' in 'field list'
You don't have a field called 'in_game'
either modify your table, or your query
Title: Good Old Problems With Php
Post by: spirit1flyer on December 02, 2005, 05:40:05 PM
can I do that through the forum admin or do I have to do it through something else?

I don't know anything about editing my table or query so I would not know were to start
Title: Good Old Problems With Php
Post by: Eddy-B on December 03, 2005, 01:13:15 AM
then how did you make it, if you don't know anything about it ?

> if someone else wrote it - contact that person and tell HIM about the error. It obviously is a bug in the system
Title: Good Old Problems With Php
Post by: spirit1flyer on December 03, 2005, 01:29:02 AM
Quote
then how did you make it, if you don't know anything about it ?

> if someone else wrote it - contact that person and tell HIM about the error. It obviously is a bug in the system

I am pretty sure that I made it but I don't know how to fix it.  
I think it was created by the installer for the arcade but it would not run this time.  It said
Code: [Select]
mySQL query error: CREATE TABLE inv_games_scores (
        s_id int(11) NOT NULL auto_increment,
                    mid int(11) NOT NULL default '0',
                    gid int(11) NOT NULL default '0',
                    name text NOT NULL,
                    score FLOAT(11) NOT NULL default '0',
                    ip text NOT NULL,
                    comment text NOT NULL,
                    datescored int(10) NOT NULL,
                PRIMARY KEY (s_id)) TYPE=MyISAM

mySQL error: Table 'inv_games_scores' already exists
mySQL error code: 
Date: Friday 02nd of December 2005 11:24:42 PM

I have installed this once before but some code problems with my forum forced me to reinstall the forum. but I guess the SQL did not change or something like that.
am I on the right idea? if so how would I go about removing TABLE inv_games_scores? or anything else that might be in the way of re-using the installer?


spirit
Title: Good Old Problems With Php
Post by: Eddy-B on December 03, 2005, 09:07:55 AM
Quote
mySQL error: Table 'inv_games_scores' already exists
You have re-installed, but you did not remove all the tables that were created by the earlier install.
It depends on how the php is written, wether this error is a terminal error (php execution stops) or it just continues with the installation process. Either way: please contact the support from which you have gotten/downloaded the forum product, and they can assist you, and tell you what is wrong.

Some other place to look would be their knowladge base or their own forum/tech support.

You can log into your server using phpmyadmin (or any other mysql tool), and delete (=drop) all tables that were created by the setup. If you have nothing else installed on your server that would be "all tables".
Title: Good Old Problems With Php
Post by: spirit1flyer on December 03, 2005, 04:10:17 PM
okay thanks I think I know how to fix it now.   But I can't  :(   I don't have the mySQL password.

it was lost when Xfir's forum went down.
so I will just have to remove the code until his site is back.  who knows how long that might take  <_<