Radicore Forum: RADICORE Installation Issues » Partial Installation it seems

Home » RADICORE » RADICORE Installation Issues » Partial Installation it seems (Some parts of the framwework are not working)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Partial Installation it seems [message #3285]

Sat, 05 January 2013 10:02

johnftr
Messages: 14
Registered: January 2013

Junior Member

I have installed version 1.77 on Windows running XAMPP. I have php 5.
Once installed I am able to create a new subsystem. It goes as far as creating the underlying directories and creating the additional subsystem name as a menu button at the top level.

When I navigate back to home I have the following buttons:
Menu System, Transix and the name of my subsystem (TEST).

When I try to get to the subsystem by clicking on that link all I see is my username displayed,the Home Page banner and then below that Session Data and List Favourites (and then Change PW, TO-DO and MOTD)

I cannot see how to get to the subsystem menu to allow me to import data etc or actually get underway with the subsystem.

I thought I had followed all the installation steps correctly - the tables are created and loaded with data from the relevant .sql scripts. I have the correct include path (using php.ini rather than the htaccess method).

Thoughts / help / comments would be very welcome as I'd love to use this RAD environment.

Report message to a moderator

Re: Partial Installation it seems [message #3286 is a reply to message #3285]

Sun, 06 January 2013 05:45

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

Please follow the tutorial at http://www.tonymarston.net/php-mysql/radicore-tutorial.html# initialisation. All you have done so far is:

You still have to do the following:

Import Database
Import Column details
Define Relationships
Export to PHP

Then you can start to build your transactions as outlined in 2. Generate Transactions. It is only when you build your transactions that they will appear on the subsystem menu.

Report message to a moderator

Re: Partial Installation it seems [message #3287 is a reply to message #3286]

Sun, 06 January 2013 06:10

johnftr
Messages: 14
Registered: January 2013

Junior Member

That's the whole problem Tony. I do not see how to import the database. The menu options that are shown in the installation instructions for database import step are not there on my installation..
In the tutorial it has two vital menu buttons on the list subsystem that I do NOT see. These are DATABASES and AUDIT TRAIL. Have I missed an SQL IMPORT file somewhere? I have repeated the installation now twice and have the same results.
Perplexed. I would love to be able to generate a system to replace my old hand-coded applications and to build additional functionality.
Thanks for your further advice.

Report message to a moderator

Re: Partial Installation it seems [message #3288 is a reply to message #3287]

Sun, 06 January 2013 08:46

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

You may have an incomplete version of the radicore/menu/sql/<db>/menu-data.sql file,which means that you will have to import each of the subsystem's data individually from the radicore/<subsystem>/sql/<subsystem>.menu_export.sql files

Then you can follow the procedure described in 3.1 Import Database

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

[Updated on: Sun, 06 January 2013 08:57]

Report message to a moderator

Re: Partial Installation it seems [message #3289 is a reply to message #3288]

Sun, 06 January 2013 09:23

johnftr
Messages: 14
Registered: January 2013

Junior Member

Excluding the classroom, survey, product or xample databases ...
As I understand it I need the following tables from the installation - Audit (created but empty), dict, menu and workflow.
After installation and the SQL loading step ....

The dict database has been created with 6 tables (with 686 total records). I have used the radicore/dict/sql/mysql/ schema and data sql scripts.

The menu database has 22 tables (1054 total records) with data from the radicore/menu/sql/mysql schema, data and mnu_user scripts.

The workflow database has 7 tables with a total of 70 records using the schema and data sql scripts.

Are there other core components (other than the examples of classroom etc)that I am missing? There are scripts at the higher level radicore/workflow/sql for example or radicore/menu/sql/ menu.menu_export, menu_delete, misc.menu_export, mnu_role_task etc
These are not mentioned in the installationguide.
Thanks.

Report message to a moderator

Re: Partial Installation it seems [message #3290 is a reply to message #3289]

Sun, 06 January 2013 12:36

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

It would appear that I included the wrong version of menu-data.sql in the download (which I have now fixed), so attached is a proper copy with all the missing data.

Attachment: menu-data.zip
(Size: 28.89KB, Downloaded 1083 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Partial Installation it seems [message #3291 is a reply to message #3290]

Sun, 06 January 2013 14:21

johnftr
Messages: 14
Registered: January 2013

Junior Member

Thank you very much! I know how much effort it all takes to do!

Report message to a moderator

Re: Partial Installation it seems [message #3292 is a reply to message #3290]

Sun, 06 January 2013 16:04

johnftr
Messages: 14
Registered: January 2013

Junior Member

Aaaahhhhhhh - success Smile

Smile

Thanks!

Report message to a moderator

Re: Partial Installation it seems [message #3302 is a reply to message #3292]

Thu, 10 January 2013 07:50

johnftr
Messages: 14
Registered: January 2013

Junior Member

I just thought I would try out the sample apps and came across a couple of small issues.
The first is that the instructions ask you to create the empty / shell databases first - and then run the SQL scripts. The schema script attempts to create the database within it and this fires an error that database already exists. Removing the line from the script (or not creating an empty database beforehand fixes this). The other issue which may cause folks problems is the TYPE=. This should probably read ENGINE= for some versions.

Report message to a moderator

Re: Partial Installation it seems [message #3303 is a reply to message #3292]

Thu, 10 January 2013 08:20

johnftr
Messages: 14
Registered: January 2013

Junior Member

I think it's just the classroom import schema script for the TYPE= error

Report message to a moderator

Re: Partial Installation it seems [message #3305 is a reply to message #3303]

Thu, 10 January 2013 09:51

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

I thought I had fixed those some while ago Sad

Sad

I've updated the sql scripts, and they will be in the next release.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Partial Installation it seems [message #3308 is a reply to message #3305]

Thu, 10 January 2013 14:05

johnftr
Messages: 14
Registered: January 2013

Junior Member

I'd be happy to help test things if you need ... Smile

Smile

Report message to a moderator

Re: Partial Installation it seems [message #3309 is a reply to message #3308]

Thu, 10 January 2013 14:50

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

I've uploaded the changed files, so you can go ahead and test them.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: Partial Installation it seems [message #3315 is a reply to message #3309]

Fri, 11 January 2013 10:36

johnftr
Messages: 14
Registered: January 2013

Junior Member

Hi Tony
I downloaded the windows.zip 1.77 version for testing
The Classroom, Product and Survey schema scripts include the create database statement still. These will fire an error if you have already created the database manually as specified in the installation:
<li>Create each database/schema manually (menu, dict, audit, workflow, classroom, product, survey, xample).</li>
<li>Create the tables in those databases/schemas from the <code>???-schema.sql</code> scripts.</li>
The xample script still has the TYPE= set in it, but does not have the create database.
Hope this helps.
Cheers, John

Report message to a moderator

Re: Partial Installation it seems [message #3316 is a reply to message #3315]

Fri, 11 January 2013 11:00

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

Silly me! I changed the scripts for each of the prototypes, and them zipped them, but I forgot to include them in the larger radicore zip file. That has now been fixed.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Installation file inconsistencies / demo user access
Next Topic:	Help ! Can not log In Radicore v1.76.0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sat Nov 23 15:31:29 EST 2024

Total time taken to generate the page: 0.09634 seconds