>> Site Map >> Forums >> Installation 7x

Forum module - topics in forum:

Installation 7x - Discussions regarding PHP-Nuke Installation and Configuration. 7x

Help Needed About MySQL!

I am trying to install MySQL and it gives me this error!

Quote: :

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Invalid Identifer @ 182
STR: 4.01.
SQL: # phpMyAdmin MySQL-Dump
# version 2.3.1-rc1
# http://www.phpmyadmin.net/ (download page)
#
# servidor: localhost
# Tiempo de generaci��08-05-2005 a las 20:26:29
# Versi��el servidor: 4.01.10
# Versi��e PHP: 5.0.3
# Base de datos : `nuke`
# --------------------------------------------------------

#
# Estructura de tabla para la tabla `nuke_authors`
#

CREATE TABLE nuke_authors (
aid varchar(25) NOT NULL default '',
name varchar(50) default NULL,
url varchar(255) NOT NULL default '',
email varchar(255) NOT NULL default '',
pwd varchar(40) default NULL,
counter int(11) NOT NULL default '0',
radminsuper tinyint(1) NOT NULL default '1',
admlanguage varchar(30) NOT NULL default '',
PRIMARY KEY (aid),
KEY aid (aid)
) ENGINE=MyISAM

SQL query:

# phpMyAdmin MySQL-Dump # version 2.3.1-rc1 # http://www.phpmyadmin.net/ (download page) # # servidor: localhost # Tiempo de generaci��08-05-2005 a las 20:26:29 # Versi��el servidor: 4.01.10 # Versi��e PHP: 5.0.3 # Base de datos : `nuke` # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_authors` # CREATE TABLE nuke_authors ( aid varchar(25) NOT NULL default '', name varchar(50) default NULL, url varchar(255) NOT NULL default '', email varchar(255) NOT NULL default '', pwd varchar(40) default NULL, counter int(11) NOT NULL default '0', radminsuper tinyint(1) NOT NULL default '1', admlanguage varchar(30) NOT NULL default '', PRIMARY KEY (aid), KEY aid (aid) ) ENGINE=MyISAM
MySQL said:

#1046 - No database selected

Can Anybody Help Me?

Try http://phpnuke-uk.net/modules.php?name=Forums&file=viewtopic&t=5040&highlight=engine+myisam

Thanks for the tip but it still dosent work. Could it be something due to its original code or due to my MySQL server?

I see in your error it lists php as version 5.0.3, maybe thats the problem, nuke doesnt really like php5.

Have you tried an installer script? does that give any errors?

http://www.nukeresources.com/downloads-cat92.html

Hi Dar,

I get this myself with PHP 5 and MySQL 5.0. I changed the charset to centraleuropean and it installs about 80% of the tables until it grinds to a halt.

Bah, this is just not going to work is it?

I don't suppose there is a Dev forum you can point me to so I can ask about a compatable version?

Thanks,
L

Generally, nuke works fine with PHP 4 and MySQL 4. If your asking about a compatibile version of nuke for your php + mysql versions, then there is no "offical" dev forums as the developer cant be arsed to offer support for his own product.

Ah nuts.

Shame really, I can't downgrade as we got hacked before with older versions of SQL. So I guess there is no way to use php-nuke.

Cypher, thanks for your help man.

Forum module - topics in forum:

Search from web