Basic site setup

[milesparker]

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.

[milesparker]

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..

[milesparker]

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..

[milesparker]

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)

[milesparker]

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

[milesparker]

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

[julien1]

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

[milesparker]

"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?

[julien1]

-- 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','[e-mail]','[e-mail]','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,'','[e-mail]','','',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)
;

[milesparker]

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

[ariebaas]

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

[milesparker]

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

[julien1]

thanks