MFGG Message Boards: Archives -> Question

Mario Fan Games Galaxy · Forum Rules 6.0 - Read before posting

Help

Members

Calendar

Chat

Welcome Guest ( Log In | Register )

Resend Validation Email

MFGG Message Boards: Archives -> General -> Help!

Question - Mysql

Track this topic | Email this topic | Print this topic

SonicProject

Posted: Jan 25 2004, 12:15 PM

Finkrats that I spit on know not of the cool I have.
[*]

Group: Members
Posts: 54900
Member No.: 56
Joined: 14-October 03

Status: (0d) [--]

I'm trying to create a MySQL table for my forum called ibf_sessions. Here's what I have so far in the 'Run New Query' box:

CODE

CREATE TABLE ibf_sessions

Now, when I try to run the query, I get this:

QUOTE (SQL Error)

A table must have at least 1 column

But I do not know how to create a column in MySQL. Can somebody just help me out here?

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

Apologies for the nostalgia.

Retriever II

Posted: Jan 25 2004, 03:17 PM

Catalyst

Group: Members
Posts: 18290
Member No.: 52
Joined: 13-October 03

Status: (0d) [--]

CODE

CREATE TABLE ibf_sessions (
id varchar(32) NOT NULL default '0',
member_name varchar(64) default NULL,
member_id mediumint(8) NOT NULL default '0',
ip_address varchar(16) default NULL,
browser varchar(64) default NULL,
running_time int(10) default NULL,
login_type tinyint(1) default NULL,
location varchar(40) default NULL,
member_group smallint(3) default NULL,
in_forum smallint(5) NOT NULL default '0',
in_topic int(10) NOT NULL default '0',
PRIMARY KEY (id),
KEY in_topic (in_topic),
KEY in_forum (in_forum)
) TYPE=MyISAM;

That's the table structure for ibf_sessions in IPB version 1.3.x

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

SonicProject

Posted: Jan 25 2004, 04:38 PM

Finkrats that I spit on know not of the cool I have.
[*]

Group: Members
Posts: 54900
Member No.: 56
Joined: 14-October 03

Status: (0d) [--]

I am trying to install the Mod Installer onto my forum. It required making a new database so I used your method and came up with this error:

QUOTE

mySQL query error: SELECT * FROM forummods ORDER BY title

mySQL error: Unknown column 'title' in 'order clause'
mySQL error code:
Date: Sunday 25th of January 2004 04:36:35 PM

What do I do?

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

Apologies for the nostalgia.

Draco Icebane

Posted: Jan 25 2004, 05:53 PM

Standard Member
[*]

Group: Banned
Posts: 52997
Member No.: 10
Joined: 13-October 03

Status: (71582612m) [XX]

QUOTE (SonicProject @ Jan 25 2004, 02:38 PM)

I am trying to install the Mod Installer onto my forum. It required making a new database so I used your method and came up with this error:

QUOTE

mySQL query error: SELECT * FROM forummods ORDER BY title

mySQL error: Unknown column 'title' in 'order clause'
mySQL error code:
Date: Sunday 25th of January 2004 04:36:35 PM

What do I do?

Tweak **** out with stuff that looks right until it works.

SonicProject	Posted: Jan 25 2004, 05:57 PM
Finkrats that I spit on know not of the cool I have. Group: Members Posts: 54900 Member No.: 56 Joined: 14-October 03 Status: (0d)	Problem is, though, I don't know what looks right and what doesn't. This is the first time I've EVER tried anything with MySQL. -------------------- Apologies for the nostalgia.

Retriever II	Posted: Jan 25 2004, 06:07 PM
Catalyst Group: Members Posts: 18290 Member No.: 52 Joined: 13-October 03 Status: (0d)	do you even have the right board version? --------------------

SonicProject

Posted: Jan 25 2004, 06:10 PM

Finkrats that I spit on know not of the cool I have.
[*]

Group: Members
Posts: 54900
Member No.: 56
Joined: 14-October 03

Status: (0d) [--]

QUOTE (Retriever II @ Jan 25 2004, 05:07 PM)

do you even have the right board version?

IPB 1.2

The table structure you provided me with worked on it for the other thing, though.

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

Apologies for the nostalgia.

Retriever II	Posted: Jan 25 2004, 06:13 PM
Catalyst Group: Members Posts: 18290 Member No.: 52 Joined: 13-October 03 Status: (0d)	But what version does the mod require? --------------------

SonicProject

Posted: Jan 25 2004, 06:23 PM

Finkrats that I spit on know not of the cool I have.
[*]

Group: Members
Posts: 54900
Member No.: 56
Joined: 14-October 03

Status: (0d) [--]

QUOTE (Retriever II @ Jan 25 2004, 05:13 PM)

But what version does the mod require?

IPB 1.2
http://mods.ibplanet.com/db/?mod=1595

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

Apologies for the nostalgia.

SonicProject	Posted: Jan 27 2004, 12:05 PM
Finkrats that I spit on know not of the cool I have. Group: Members Posts: 54900 Member No.: 56 Joined: 14-October 03 Status: (0d)	I do still need help. I hope you guys can help me here. -------------------- Apologies for the nostalgia.

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)

0 Members:

« Next Oldest | Help! | Next Newest »

Topic Options

[ Script Execution time: 0.0666 ] [ 14 queries used ] [ GZIP Enabled ] [ Server Load: 3.84 ]