Create planet

Tarnus · **Joined:** Wed Feb 19, 2003 12:17 pm **Posts:** 2619

Rici_CZ wrote:

I have a problem with game on my server of game. I can`t create planet. If i use order for create planet with use genesis torpedo, planet is created but is not writed to the database. In admin log file are writed this errors:

A Database error occurred in /home/o/onlinegame.cz/public_html/subdomeny/sa2/global_funcs.php on line 1742 (called from: /genesis.php): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '5,5,'80.188.110.183',1,'2003-12-29 22:33:33')' at line 1

A Database error occurred in /home/o/onlinegame.cz/public_html/subdomeny/sa2/genesis.php on line 191 (called from: /genesis.php): Unknown column ' prod_energy' in 'field list'

Configure server:
PHP: 4.3.4
MySQL: 4.0.15
Apache: 1.3.27
Relase game: 0.14.1 W/profiles

file info.php: http://www.onlinegame.cz/info.php

do you know someone where is a mystake or what order to use for correct run of game??

Was it a fresh install? Or are you upgrading to a new version?

Tarnus · **Joined:** Wed Feb 19, 2003 12:17 pm **Posts:** 2619

Rici_CZ wrote:

Was it a fresh install.

Hmmm have you dloaded and installed the patches? I'm not sure if that will fix it or not.

That one is very strange it sounds like a field wasn't created. Did you have any error when you did the initial create universe?

Panama Jack · **Joined:** Wed Feb 19, 2003 6:07 pm **Posts:** 2930

It sounds like you have a corrupted planets table in your database.

Code: Select all

Unknown column ' prod_energy' in 'field list'

There should always be be a prod_energy field in the planets table. There has been one since we started working on the game.

Panama Jack · **Joined:** Wed Feb 19, 2003 6:07 pm **Posts:** 2930

There is definately something wrong with your database.

Code: Select all

A Database error occurred in /home/o/onlinegame.cz/public_html/subdomeny/sa2/genesis.php on line 191 (called from: /genesis.php): Unknown column ' prod_energy' in 'field list'

You see that error line? It is saying that the prod_energy field is missing in the database table.

Panama Jack · **Joined:** Wed Feb 19, 2003 6:07 pm **Posts:** 2930

mysql version you are using should be ok.

The other error you posted happened because the FIRST error occured. You get rid of the first error and the second will not happen. It's weird because for some reason it thinks there is a missing field in that table.

Panama Jack · **Joined:** Wed Feb 19, 2003 6:07 pm **Posts:** 2930

All I can suggest at this time is to try and reinstall the game.

Tarnus · **Joined:** Wed Feb 19, 2003 12:17 pm **Posts:** 2619

Rici_CZ wrote:

I tried to make a full reinstallation of the game, tried to delete and create whole database including the latest version of file, however there is no effect.

The only thing I´ve found out is that there is not possible to create a new planet in database version 4.0.15, and in version 4.0.17 it´s all right.

However that doesn´t solve my trouble - I have only 4.0.15 version for the program hosting.

Do you have any idea how to resolve the problem, except for the upgrade of a d-base?

:cry:

That is one of the strangest errors I have seen. It works in .17 but not in .15 I would say there is a serious bug in the .15 ver of the database and that maybe why it has been updated. An update of the dbase software should not cause any problems with current databases on the server. So I would see if you can talk the hosting company into doing the upgrade and notate that its due to a bug that is preventing some software from working correctly.

Panama Jack · **Joined:** Wed Feb 19, 2003 6:07 pm **Posts:** 2930

I would say that you have something congifured improperly on mysql because when you create a planet it is using a standard insert command for inserting a new record into the planets database.

The command isn't any different from the others in the game inserting things like ships, players and other data.

Create planet

Who is online