"Sommaire Parametrable" Menu Navigation Block Inst

Nuke Cadet Joined: Sep 16, 2003 Posts: 2

Hello All

I am trying to install the above block & module and have followed the procedure for copying all files into the relevant directories in phpNuke.

As a newbie I thought I was making some progress with this php stuff but I think my hurdle is sql not php.

I can't figure out how to install the 2 tables required into my nuke database. I have visited various forums on different sites and observed some useful instructions on using command line instructions. But all of these require shell access which I don't have and frankly, all that seems way too hard for what should be a simple exercise.

I have been into mysql database and phpmyadmin, but my versions do not have an import function - it is all data maintenance and exporting but not importing.

Can someone who has installed this block/module please give me some pointers.

Thank you in advance. I am loving phpNuke but it is very new to me and therefore a little frustrating.

Thanks !

Posted: Tue Sep 16, 2003 8:59 am

ok, so you have to follow these steps :

1. log on PHPMyadmin

2. Select your DB (in the left frame)
--> you will see the list of tables in the left frame, and a table listing all the tables with some infos in the right frame.

3. just after the end of this table (on the right frame), you will se a box where you can execute requests (just under 'Printable Version')
JUST AFTER this box, you have another box, named somthing like "...Or text file", with a button "Browse"
You just click 'browse', and choose the file 'install-sommairev2.sql' on your hard drive.
Click OK, PHPMyAdmin will execute the sql script ("importing" the data in your DB)

--> the 2 tables are created.

Marc

note : I translated approximatively what you should see in english, so don't be surprised if the text is not exactly the same as i described.

Nuke Cadet Joined: Sep 16, 2003 Posts: 2

Thanks Marc for your helpful instructions. I did this but I do not seem to have this option. No browse button. Just a create table button and a fields input.

See screenshot of my phpmyadmin screen

[url][/url]

- phpmyadmin version is 2.5.2
- mysql version is 4.0.15-standard

Any other options ?

Thanks...

Posted: Wed Sep 17, 2003 7:45 am

I see a link "Query window" on the bottom of the left frame : try clicking it, perhaps you will be able to "import" the file.

if this does not work, i'll make you a php file to install the db tables. (it's easy to do)

Corporal Joined: May 02, 2003 Posts: 70

you should be able to ckick on that "douglasr_nuke1" up top in the left hand side..

then it should open a page that has some tabs accross the top. Click on the tab that says "SQL" then you should see some instructions that will allow you to browse your computer for the .sql file that you are wanting to install.

casper

Nuke Soldier Joined: Sep 18, 2003 Posts: 10

Did you ever get this to work? I am also having problems importing a file into my database. IT wont allow me to do it.

Posted: Sat Oct 04, 2003 4:23 pm

I've installed this module/block, but I need help adding content to the categories... tsk. (blah, it's simple right, you fill in all the blanks, and save your modifications, then you go back and theres a new spot... genius!)

If you're using a hosting service, they should have a control panel which allows you to look at the database.

Also if you have PHP-Nuke which you installed yourself, you should have some knowledge of how to load in the SQL files?

But I am having a problem seeing my menu... sigh.

Posted: Sun Oct 05, 2003 4:04 am

Ok, so in fact my file 'install-sommairev2.sql' sed the default DB prefix name, 'nuke' : so the tables created were 'nuke_sommaire' and 'nuke_sommaire-categories'.

if you changed the DB prefix name, it won't work.

I made quickly a php file in order to install the 2 tables automatically, using your $prefix.

--> Donwload it HERE

glock > perhaps with this file you should be able to bypass the IT restriction.

nhl23 > did you add the block 'sommaire' ? (go to nuke's admin panel then click 'Blocks'. under the list of installed blocks, you can add a new block (select 'Sommaire' in the list box), then choose where to display this block - normally at top left !, and you can de-activate the original 'block-modules' block)

Posted: Sun Oct 05, 2003 6:48 pm

All of my troubles pertaining to Sommaire have been fixed...