12 Replies Latest reply on Jul 22, 2004 4:40 AM by Viet

    Basic site setup

    milesparker Newbie


      This is very basic, but I have looked everywhere on Wiki and searched in forum for information on setting up pages and menus (sections?) Something as simple as adding a new page in addition to "home".

      I understand the block concept and everything, and I have played around with all of the admin tools and none of them seem to provide what I'm looking for...I've never used phpNukes, perhpas that is why this is so non-obvious to me.

      A Wiki page on simply creating content would be very helpful for full-noobs like me.

        • 1. Re: Basic site setup
          milesparker Newbie

          Perhpas I have something misconfigured...when I do "manage html" I can create a new page, but it doesn't look as though anything gets created...I have searched through the Jboss dir's to find the created web page, and when I select it in the "manage html" page, nothing gets displayed...hmmm..

          • 2. Re: Basic site setup
            milesparker Newbie

            Checked the server logs and getting this:

            004-07-09 11:40:18,609 ERROR [STDERR] javax.ejb.FinderException: Find failed: java.sql.SQLException: General error, message from server: "Table 'nukes.nuke_filestat' doesn't exist"

            At least I know its not just me...:-) I'll try to run the setup.ddl again and see if that takes care of it..

            • 3. Re: Basic site setup
              milesparker Newbie

              OK, this looks like it is not part of the ddl setup but perhaps is created by nukes internal setup...? Here is the error I'm getting:

              2004-07-09 11:43:25,578 ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.FileStatEJB] Error checking if entity exists
              java.sql.SQLException: General error, message from server: "Table 'nukes.nuke_filestat' doesn't exist"
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)
              at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)
              at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1555)
              at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:304)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCInsertPKCreateCommand.beforeInsert(JDBCInsertPKCreateCommand.java:83)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:137)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:554)
              at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:208)
              at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:269)
              at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:581)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:324)
              at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1043)
              at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
              at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:197)
              at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:214)
              at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88)
              at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:89)
              at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61)
              at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28)
              at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88)
              at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
              at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:98)
              at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92)
              at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120)
              at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93)
              at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:483)
              at org.jboss.ejb.Container.invoke(Container.java:720)
              at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:293)
              at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
              at $Proxy46.create(Unknown Source)
              at org.jboss.nukes.core.modules.html.HtmlModule$4.execute(HtmlModule.java:1223)
              at org.jboss.nukes.core.ejb.UtilsEJB$Executable.execute(UtilsEJB.java:119)
              at org.jboss.nukes.core.ejb.UtilsEJB.requiresNew(UtilsEJB.java:95)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:324)
              at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
              at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
              at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
              at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
              at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
              at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
              at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
              at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
              at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
              at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
              at org.jboss.ejb.Container.invoke(Container.java:700)
              at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:375)
              at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83)
              at $Proxy61.requiresNew(Unknown Source)
              at org.jboss.nukes.core.modules.html.HtmlModule$3.run(HtmlModule.java:1214)
              at org.jboss.nukes.utils.Scheduler$MutexTask.run(Scheduler.java:87)
              at java.util.TimerThread.mainLoop(Timer.java:432)
              at java.util.TimerThread.run(Timer.java:382)

              • 4. Re: Basic site setup
                milesparker Newbie


                OK, I see this issue is also occuring here:

                http://www.jboss.org/index.html?module=bb&op=viewtopic&t=51377

                Guess that's why its called a release "candidate". :-D

                • 6. Re: Basic site setup
                  Viet Master

                  try to source the file nukes/nukes/output/resources/mysql/setup.ddl it contains the statement to create the table nuke_filestat

                  • 7. Re: Basic site setup
                    milesparker Newbie

                     

                    "cooper" wrote:
                    try to source the file nukes/nukes/output/resources/mysql/setup.ddl it contains the statement to create the table nuke_filestat


                    Thx. Unfortunatly, build is giving weird errors (I'm stuck on a windows machine right now). Could someone just post the correct setup.ddl text here?

                    • 8. Re: Basic site setup
                      Viet Master

                       

                      
                      -- module : nukes - Nukes Core Module
                      -- database : mysql - MySQL
                      --
                      -- WARNING:
                      -- This file is generated automatically, please do not modify it
                      -- directly, your changes will be lost during next generation.
                      -- Modify the setup.xml file to make permanent changes.
                      
                      
                      --
                      -- Drop tables
                      --
                      
                      -- Drops Users table
                      DROP TABLE IF EXISTS nuke_users;
                      -- Drops Groups table
                      DROP TABLE IF EXISTS nuke_groups;
                      -- Drops Group Membership table
                      DROP TABLE IF EXISTS nuke_group_membership;
                      -- Drops Files table
                      DROP TABLE IF EXISTS nuke_file;
                      -- Drops Files Stat table
                      DROP TABLE IF EXISTS nuke_filestat;
                      -- Drops Services table
                      DROP TABLE IF EXISTS nuke_services;
                      -- Drops Services Attributes table
                      DROP TABLE IF EXISTS nuke_services_attributes;
                      
                      --
                      -- Create tables
                      --
                      
                      -- Creates Users table
                      CREATE TABLE `nuke_users` ( `pn_uid` int(11) NOT NULL auto_increment, `pn_uname` varchar(25) NOT NULL, `pn_user_regdate` datetime NOT NULL, `pn_user_viewemail` tinyint(1) NOT NULL default '1', `pn_name` varchar(60) NOT NULL default '', `pn_email` varchar(60) NOT NULL default '', `pn_femail` varchar(60) NOT NULL default '', `pn_url` varchar(254) NOT NULL default '', `pn_timezone_offset` tinyint(4) NOT NULL default '0', `pn_user_avatar` varchar(30) NOT NULL default 'blank.gif', `pn_user_icq` varchar(15) NOT NULL default '', `pn_user_aim` varchar(18) NOT NULL default '', `pn_user_yim` varchar(25) NOT NULL default '', `pn_user_msnm` varchar(25) NOT NULL default '', `pn_user_from` varchar(100) NOT NULL default '', `pn_user_lang` int(3) NOT NULL default '0', `pn_user_occ` varchar(100) NOT NULL default '', `pn_user_intrest` varchar(150) NOT NULL default '', `pn_user_sig` varchar(255) NOT NULL default '', `pn_bio` tinytext NOT NULL default '', `pn_pass` varchar(40) NOT NULL default '', `pn_theme` varchar(255) NOT NULL default '', `pn_umode` varchar(10) NOT NULL default '', `pn_uorder` tinyint(1) NOT NULL default '0', `pn_thold` tinyint(1) NOT NULL default '0', `pn_noscore` tinyint(1) NOT NULL default '0', `pn_commentmax` int(11) NOT NULL default '4096', `pn_last_visit` datetime NOT NULL default '1974-09-21 00:00:00', `pn_prev_last_visit` datetime NOT NULL default '1974-09-21 00:00:00', `pn_question` tinytext NOT NULL default '', `pn_answer` tinytext NOT NULL default '', `pn_enabled` tinyint(1) NOT NULL default '1', PRIMARY KEY (`pn_uid`), UNIQUE INDEX (`pn_uname`) );
                      -- Create Group Membership table
                      CREATE TABLE `nuke_group_membership` ( `pn_gid` int(11) NOT NULL, `pn_uid` int(11) NOT NULL, PRIMARY KEY (`pn_uid`, `pn_gid`) );
                      -- Creates Groups table
                      CREATE TABLE `nuke_groups` ( `pn_gid` int(11) NOT NULL auto_increment, `pn_name` varchar(255) NOT NULL default '', PRIMARY KEY (`pn_gid`) );
                      -- Creates File table
                      CREATE TABLE `nuke_file` ( `pn_id` int(11) NOT NULL auto_increment, `pn_fid` varchar(255) NOT NULL, `pn_uid` int(11) NULL, `pn_content_type` varchar(50) NOT NULL, `pn_content` longblob NOT NULL, `pn_timest` datetime NOT NULL, `pn_public` tinyint(1) NOT NULL default '0', PRIMARY KEY (`pn_id`), INDEX (`pn_fid`) );
                      -- Creates File Statistics table
                      CREATE TABLE `nuke_filestat` ( `pn_vmid` varchar(16) NOT NULL, `pn_id` bigint NOT NULL, `pn_from` bigint NOT NULL, `pn_length` bigint NOT NULL default '0', `pn_view_count` bigint NOT NULL default '0', PRIMARY KEY (`pn_vmid`,`pn_id`,`pn_from`) );
                      -- Creates Services table
                      CREATE TABLE `nuke_services` ( `pn_sid` varchar(128) NOT NULL, `pn_last_modified` bigint NOT NULL, `pn_class_name` varchar(255) NOT NULL, PRIMARY KEY (`pn_sid`) );
                      -- Creates Services Attributes table
                      CREATE TABLE `nuke_services_attributes` ( `pn_sid` varchar(128) NOT NULL, `pn_aid` varchar(128) NOT NULL, `pn_value` text NULL default NULL, PRIMARY KEY(pn_sid, pn_aid) );
                      
                      --
                      -- Insert default init values
                      --
                      
                      -- Insert Admin account
                      INSERT INTO nuke_users VALUES (1,'admin','2003-12-11 18:57:21.074',1,'Administrator','admin@none.com','fake-admin@none.com','http://www.mysite.com',0,'blank.gif','','','','','',0,'','','Nukes CMS Administrator','','21232F297A57A5A743894A0E4A801FC3','imagic','',0,0,0,4096,'2003-12-14 01:15:27.8','2003-12-14 01:15:27.8','','', 1);
                      -- Insert User account
                      INSERT INTO nuke_users VALUES (2,'user','2003-12-11 18:57:21.08',1,'','user@none.com','','',0,'blank.gif','','','','','',0,'','','','','EE11CBB19052E40B07AAC0CA060C23EE','','',0,0,'0',4096,'1974-09-21 00:00:00.0','1974-09-21 00:00:00.0','','', 1);
                      -- Insert Admins group
                      INSERT INTO nuke_groups (pn_gid,pn_name) VALUES (1,'Admins');
                      -- Insert Users group
                      INSERT INTO nuke_groups (pn_gid,pn_name) VALUES (2,'Users');
                      -- Insert Admin as an Admins member
                      INSERT INTO nuke_group_membership (pn_gid, pn_uid) VALUES (1,1);
                      -- Insert User as a Users member
                      INSERT INTO nuke_group_membership (pn_gid, pn_uid) VALUES (2,2);
                      -- Insert Index file
                      INSERT INTO nuke_file VALUES (1,'/index',1,'text/html','blah','2003-12-14 19:26:50',1)
                      ;


                      • 9. Re: Basic site setup
                        milesparker Newbie

                        Excellent, that worked. Now that I have access to the html manager hopefully I can figure a bit more out...

                        • 10. Re: Basic site setup
                          arie baas Newbie

                          I am also looking for a step by step document to setup a complete site like jboss.org (setting up pages and menus).

                          • 11. Re: Basic site setup
                            milesparker Newbie

                            I put a basic (and probably incorrect) guide based on my expereinces on Wiki. Look for SettingSiteUp in Help.

                            • 12. Re: Basic site setup
                              Viet Master

                              thanks