help with MySQL

[<<Hybrid>>]

anyone know how to configure phpnuke? i got this after instalation:


Warning: main(language/lang-.php): failed to open stream: No such file or directory in /home/cfcilyfd/public_html/phpnuke/html/mainfile.php on line 166

Warning: main(): Failed opening &#39;language/lang-.php&#39; for inclusion (include_path=&#39;.:/usr/lib/php:/usr/local/lib/php&#39;) in /home/cfcilyfd/public_html/phpnuke/html/mainfile.php on line 166

Warning: head(themes//theme.php): failed to open stream: No such file or directory in /home/cfcilyfd/public_html/phpnuke/html/header.php on line 31

Warning: head(): Failed opening &#39;themes//theme.php&#39; for inclusion (include_path=&#39;.:/usr/lib/php:/usr/local/lib/php&#39;) in /home/cfcilyfd/public_html/phpnuke/html/header.php on line 31

Fatal error: Call to undefined function: themeheader() in /home/cfcilyfd/public_html/phpnuke/html/header.php on line 47

do i need to configure or edit some file? (i edited config.php file) what to do now?

[Grimmy]

The first one looks like it is looking for a file in that path, that isn&#39;t there. The others could be a permission setting on the folders. Might try CHMODing them to 777 or something like that.

[<<Hybrid>>]

i tried all to search this CHMOD. i heard alot about it. but i cant find where to edit this CHMOD. At homepage settings or at programm config/settings?

[JIMINATOR]

chmod is a unix command to change the properties of a file folder
if you have shell access (where you can go and type commands)
looking at the errors though, it kind of looks like it wasn&#39;t installed correctly.

[Grimmy]

I use smartftp to upload my files, and it&#39;s a matter of like right clicking on the folder and then choosing CHMOD, adjust the setting and click ok. ;)

[<<Hybrid>>]

oh. I am using standart FTP browser - IE, not enought money to buy programs for now...
is that possible to change CHMOD for me?. We havent any free website or anything else. Its expensiviest hosting what DA found with all extras. Do i have any chance now?

[Grimmy]

smartftp is free. ;)

[Nitro]

nuke? :blink:

[<<Hybrid>>]

ok thanks alot grimox&#33; ;)

and yes nitrostatic, its called PHPnuke. With it you can create design like this --&#62; campersclan (http://www.campersclan.de) or siply this --&#62; GMs homepage (http://www.gamemecca.net)

its very powerful online editor

[<<Hybrid>>]

nope i changed CHMOD to 777. (lol that was simlpe file permissions to groups user, owner and anonymous)

nothing happens

here is instalation help:

Installing the Package
----------------------

Untar the package into the directory you want to use on you web
server, if you&#39;re unsure where that is, ask you system administrator.
(Windows users can use WinZip or WinRAR to uncompress .tar.gz files)

tar -zxvf PHP-Nuke.tar.gz

Now go to the directory where you uncompressed all files and edit the
file "config.php". Change all the fields until you are happy with the
changes and they fits the need of your web site. Give special attention
to the database configuration section. When you have finished to edit
config.php file change to the /sql/ directory and there is a file called
"nuke.sql" this file contains the commands to build the database structure,
tables and the default data.

1) Create a database called, for example, nuke:

&nbsp; &nbsp; mysqladmin create nuke
&nbsp; &nbsp;
2) Now fill the databases with the tables in nuke.sql file:

&nbsp; &nbsp; mysql nuke < nuke.sql

3) In order to use the ultramode.txt news file please be sure to chmod 666.
&nbsp; This file is used to show news from your site in some old programs and
&nbsp; frontends and is reserved to future use in PHP-Nuke. For backend use
&nbsp; backend.php file instead.

4) That&#39;s it&#33;... now you need to edit the file "config.php" to set the
database options. Please read carefully the instruction on that file&#33;
After that, point your browser to:

http://yourdomain.com/admin.php
&nbsp; &nbsp;
&nbsp; &nbsp; We use MySQL as the example and nuke.sql file is in MySQL format
because PHP-Nuke was made using this database server. You can find
many programs out there to convert the database schema from MySQL to
whatever else you want. But this is a task for you.


I did only config.php
i dont know how to modify or add tables to mysql :bandhead:

[Grimmy]

Guessing here, but once you create the database named nuke, there should be a way you create the tables from a file, thinking it is that nuke.sql. From my experiences, you browse for the file on your HD, and open it and it creates all the tables and such.

Check this file path: /home/cfcilyfd/public_html/phpnuke/html/mainfile.php on line 166

What does line 166 say in that mainfile.php?

[EXEcution]

Can we just let Grimmy do it for us? :P

[Slice]

Normally your host has a control panel that you can access and manage your sql. There you have to normally set up a username and password to be able to create tables. You need to make a table in which your database will be stored on to. Also if they are a good host they will have PHPMyAdmin installed server side which you connect to and can make individual database changes.

[Slice]

Here is an example of the control panel in which you make, create and can delete databases with.

Note: I altered some of the text on this page to protect our database.

[Grimmy]

He had the stuff in your second pic Slice. Went into myphpadmin and created the DB there, and just had a small prob with the .sql file that you use that makes all the tables and that fun stuff for ya.

Hope he gets it working. I showed him a few things today, so time will tell. :)

[<<Hybrid>>]

first of all Grimmy is a GENIOUS&#33;&#33;&#33;&#33;&#33; :wootrock:

thanks alot man, that MYPHPADMIN cr@p helped me. I didnt uploaded this sql file, becouse there was wrong commands at start. I just pasted all table add cmds

lol i uploaded site at wrong directory, gonna move, becouse of our forums

so. i am glad i am leaving this topic :D

soon we&#39;ll have one of best homepage looks

[Grimmy]

:jammin: Glad ya got it all working :thumbs:

[<<Hybrid>>]

i did reinstall, becouse i had "Acess Denied " at all features :banghead:

hope that will help