New version
39 views
Skip to first unread message
Marcin M.
Aug 3, 2011, 4:05:44 AM8/3/11
to PorPOISe
When will be new version of Porpoise for layar 6.0?
Menno Bieringa
Aug 24, 2011, 11:48:51 AM8/24/11
to PorPOISe
A Beta version has just been uploaded.
Feel free to test it and report found bugs.
Surely there will be quite some.
Feel free to test it and report found bugs.
Surely there will be quite some.
Nico Knoester
Aug 29, 2011, 9:47:32 AM8/29/11
to PorPOISe
Hi,
i get a message when i try to import the example database provided! It
has to do with the constraints!?
anyone? Thanks.
------------------------
Error
SQL query:
--
-- Constraints for dumped tables
--
--
-- Constraints for table `action`
--
ALTER TABLE `Action` ADD CONSTRAINT `Action_ibfk_1` FOREIGN KEY
( `poiId` ) REFERENCES `poi` ( `id` ) ON DELETE CASCADE ON UPDATE
CASCADE ;
MySQL said:
#1005 - Can't create table './host_databasename/
#sql-104e_13ddd5.frm' (errno: 150) (Details...)
--------------------------
Nico Knoester
Aug 30, 2011, 2:17:33 PM8/30/11
to PorPOISe
posted it as a new topic since it keeps me from adding POIS to my
layar! tnx
layar! tnx
Menno
Aug 30, 2011, 6:44:30 PM8/30/11
to porp...@googlegroups.com
Hi Nico,
I've been able to reproduce your issue under linux with a different version of MySQL.
Can you try the creation statements below?
Since you say you have no data in your porpoise database, please delete the already existing tables first.
Let us know if this worked,
Menno
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS `Action` (
`id` int(11) NOT NULL auto_increment,
`uri` varchar(1024) default NULL,
`label` varchar(255) default NULL,
`poiId` int(11) default NULL,
`contentType` varchar(255) default NULL,
`method` varchar(50) default NULL,
`activityType` int(11) default NULL,
`params` varchar(1024) default NULL,
`closeBiw` tinyint(1) default '0',
`showActivity` tinyint(1) default '1',
`activityMessage` varchar(255) default NULL,
`autoTrigger` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Can ONLY be used with feature tracked images',
`autoTriggerRange` int(11) default NULL,
`autoTriggerOnly` tinyint(1) default '0',
PRIMARY KEY (`id`),
KEY `poiId` (`poiId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `Animation` (
`id` int(11) NOT NULL auto_increment,
`poiId` int(11) default NULL,
`event` varchar(50) NOT NULL,
`type` varchar(50) NOT NULL,
`length` int(11) NOT NULL,
`delay` int(11) default NULL,
`interpolation` varchar(50) default NULL,
`interpolationParam` double default NULL,
`persist` tinyint(1) default '0',
`repeat` tinyint(1) default '0',
`from` double default NULL,
`to` double default NULL,
`axis` varchar(50) default NULL,
PRIMARY KEY (`id`),
KEY `poiId` (`poiId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `Layer` (
`layer` varchar(255) default NULL,
`refreshInterval` int(11) default '300',
`refreshDistance` int(11) default '100',
`fullRefresh` tinyint(1) default '1',
`showMessage` varchar(1024) default NULL,
`id` int(11) NOT NULL auto_increment,
`biwStyle` varchar(9) default NULL,
`disableClueMenu` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
CREATE TABLE IF NOT EXISTS `POI` (
`biwStyle` varchar(9) default NULL,
`doNotIndex` tinyint(1) unsigned default NULL,
`id` int(11) NOT NULL auto_increment,
`imageURL` varchar(1024) default NULL,
`layerID` int(11) default NULL,
`showBiwOnClick` tinyint(1) unsigned default '1',
`showSmallBiw` tinyint(1) unsigned default '1',
`anchor_geolocation_alt` float default NULL,
`anchor_geolocation_lat` double default NULL,
`anchor_geolocation_lon` double default NULL,
`anchor_referenceImage` varchar(64) character set ascii default NULL,
`icon_type` int(4) default NULL,
`icon_url` varchar(128) default NULL COMMENT 'Use either an icon_type or an icon_url. Both makes no sense',
`object_contentType` varchar(64) default NULL,
`object_reducedURL` varchar(255) default NULL,
`object_size` float default NULL,
`object_url` varchar(255) character set ascii default NULL,
`text_description` text character set utf8,
`text_footnote` varchar(255) character set utf8 default NULL,
`text_title` varchar(255) character set utf8 default NULL,
`transform_rotate_angle` int(11) default NULL,
`transform_rotate_axis_x` float unsigned default '0',
`transform_rotate_axis_y` float unsigned default '0',
`transform_rotate_axis_z` float unsigned default '0',
`transform_rotate_rel` tinyint(1) default NULL,
`transform_scale` float default NULL,
`transform_translate_x` float unsigned default '0',
`transform_translate_y` float unsigned default '0',
`transform_translate_z` float unsigned default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
ALTER TABLE `Action`
ADD CONSTRAINT `Action_ibfk_1` FOREIGN KEY (`poiId`) REFERENCES `POI` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `Animation`
ADD CONSTRAINT `Animation_ibfk_1` FOREIGN KEY (`poiId`) REFERENCES `POI` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
Nico Knoester
Aug 31, 2011, 12:28:58 PM8/31/11
to PorPOISe
Hi,
This worked, no error message anymore.
although when i enter in dashboard it gives me the error:
Database error: SQLSTATE[42S02]: Base table or view not found: 1146
Table 'my_databasename.layer' doesn't exist
tnx for helping out!
This worked, no error message anymore.
although when i enter in dashboard it gives me the error:
Database error: SQLSTATE[42S02]: Base table or view not found: 1146
Table 'my_databasename.layer' doesn't exist
tnx for helping out!
Marcin M.
Sep 3, 2011, 2:29:19 PM9/3/11
to PorPOISe
Same error: Database error: SQLSTATE[42S02]: Base table or view not
found: 1146 Table 'database_layar.layer' doesn't exist
found: 1146 Table 'database_layar.layer' doesn't exist
Nico Knoester
Sep 7, 2011, 6:34:50 AM9/7/11
to PorPOISe
anybody found a solution for this issue yet! I can not imagine nobody
is running a poroise server yet! Let us know please!!
is running a poroise server yet! Let us know please!!
Pedro
Sep 7, 2011, 7:14:16 AM9/7/11
to porp...@googlegroups.com
My version 1.2 is working, showing the pois in layar site, test session.
But nothing shows in the android app.
Dashboard not working to.
But nothing shows in the android app.
Dashboard not working to.
Txumari
Sep 7, 2011, 12:59:29 PM9/7/11
to PorPOISe
Sorry but I get run any version of porpoise althought the dashboard
always get some errors. But you can edit the database.
always get some errors. But you can edit the database.
Nico Knoester
Sep 8, 2011, 3:16:57 AM9/8/11
to PorPOISe
cool, tnx for your reactions guys.
anyone got an answer on this issue:
Database error: SQLSTATE[42S02]: Base table or view not found: 1146
Table 'my_databasename.layer' doesn't exist
tnx again!
anyone got an answer on this issue:
Database error: SQLSTATE[42S02]: Base table or view not found: 1146
Table 'my_databasename.layer' doesn't exist
ADSL Communications
Sep 8, 2011, 3:22:34 AM9/8/11
to porp...@googlegroups.com
Silly one but just in case....check your dB table name as error seems to imply that it's not being found?
Nico Knoester
Sep 8, 2011, 4:47:22 AM9/8/11
to PorPOISe
hi,
i did run the code above, consisting of this layar table:
CREATE TABLE IF NOT EXISTS `Layer` (
`layer` varchar(255) default NULL,
`refreshInterval` int(11) default '300',
`refreshDistance` int(11) default '100',
`fullRefresh` tinyint(1) default '1',
`showMessage` varchar(1024) default NULL,
`id` int(11) NOT NULL auto_increment,
`biwStyle` varchar(9) default NULL,
`disableClueMenu` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
On 8 sep, 09:22, ADSL Communications <adslco...@googlemail.com> wrote:
> Silly one but just in case....check your dB table name as error seems to imply that it's not being found?
>
Menno Bieringa
Sep 8, 2011, 8:00:32 PM9/8/11
to porp...@googlegroups.com
So also older versions give you errors? And what do you mean with "you can edit the database"?
FYI: i'm currently travelling but I expect to get some work done in the upcoming week.
Maybe i can remove the entire foreign key thing and just do it in PHP.
That would save some people some trouble
Menno
Txumari
Sep 9, 2011, 2:38:56 AM9/9/11
to PorPOISe
I get errors when I try to add data using the dashboard. But never
when I try to install the database.
Then to add data I have to edit the database data directly.
On 9 sep, 02:00, Menno Bieringa <mbieri...@gmail.com> wrote:
> So also older versions give you errors? And what do you mean with "you can edit the database"?
>
> FYI: i'm currently travelling but I expect to get some work done in the upcoming week.
> Maybe i can remove the entire foreign key thing and just do it in PHP.
> That would save some people some trouble
>
> Menno
>
when I try to install the database.
Then to add data I have to edit the database data directly.
On 9 sep, 02:00, Menno Bieringa <mbieri...@gmail.com> wrote:
> So also older versions give you errors? And what do you mean with "you can edit the database"?
>
> FYI: i'm currently travelling but I expect to get some work done in the upcoming week.
> Maybe i can remove the entire foreign key thing and just do it in PHP.
> That would save some people some trouble
>
> Menno
>
Menno Bieringa
Sep 13, 2011, 5:30:56 PM9/13/11
to PorPOISe
Hi Nico,
Given the error #1005 and some googling I ran into this post:
http://verysimple.com/2006/10/22/mysql-error-number-1005-cant-create-table-mydbsql-328_45frm-errno-150/
Based on what I read here I made some minor changes. Please try this
SQL.
Keep us posted!
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
CREATE TABLE IF NOT EXISTS `action` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uri` varchar(1024) DEFAULT NULL,
`label` varchar(255) DEFAULT NULL,
`poiId` int(11) NOT NULL,
`contentType` varchar(255) DEFAULT NULL,
`method` varchar(50) DEFAULT NULL,
`activityType` int(11) DEFAULT NULL,
`params` varchar(1024) DEFAULT NULL,
`closeBiw` tinyint(1) DEFAULT '0',
`showActivity` tinyint(1) DEFAULT '1',
`activityMessage` varchar(255) DEFAULT NULL,
`autoTrigger` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Can
`autoTriggerOnly` tinyint(1) DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `animation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`poiId` int(11) NOT NULL,
`interpolation` varchar(50) DEFAULT NULL,
`interpolationParam` double DEFAULT NULL,
`persist` tinyint(1) DEFAULT '0',
`repeat` tinyint(1) DEFAULT '0',
`from` double DEFAULT NULL,
`to` double DEFAULT NULL,
`axis` varchar(50) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `layer` (
`layer` varchar(255) DEFAULT NULL,
`refreshInterval` int(11) DEFAULT '300',
`refreshDistance` int(11) DEFAULT '100',
`fullRefresh` tinyint(1) DEFAULT '1',
`showMessage` varchar(1024) DEFAULT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
`biwStyle` varchar(9) DEFAULT NULL,
`disableClueMenu` tinyint(1) unsigned NOT NULL DEFAULT '0',
CREATE TABLE IF NOT EXISTS `poi` (
`biwStyle` varchar(9) DEFAULT NULL,
`doNotIndex` tinyint(1) unsigned DEFAULT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
`imageURL` varchar(1024) DEFAULT NULL,
`layerID` int(11) DEFAULT NULL,
`showBiwOnClick` tinyint(1) unsigned DEFAULT '1',
`showSmallBiw` tinyint(1) unsigned DEFAULT '1',
`anchor_geolocation_alt` float DEFAULT NULL,
`anchor_geolocation_lat` double DEFAULT NULL,
`anchor_geolocation_lon` double DEFAULT NULL,
`anchor_referenceImage` varchar(64) CHARACTER SET ascii DEFAULT
NULL,
`icon_type` int(4) DEFAULT NULL,
`icon_url` varchar(128) DEFAULT NULL COMMENT 'Use either an
`object_reducedURL` varchar(255) DEFAULT NULL,
`object_size` float DEFAULT NULL,
`object_url` varchar(255) CHARACTER SET ascii DEFAULT NULL,
`text_description` text CHARACTER SET utf8,
`text_footnote` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`text_title` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`transform_rotate_angle` int(11) DEFAULT NULL,
`transform_rotate_axis_x` float unsigned DEFAULT '0',
`transform_rotate_axis_y` float unsigned DEFAULT '0',
`transform_rotate_axis_z` float unsigned DEFAULT '0',
`transform_rotate_rel` tinyint(1) DEFAULT NULL,
`transform_scale` float DEFAULT NULL,
`transform_translate_x` float unsigned DEFAULT '0',
`transform_translate_y` float unsigned DEFAULT '0',
`transform_translate_z` float unsigned DEFAULT '0',
ALTER TABLE `action`
ADD CONSTRAINT `Animation_ibfk_1` FOREIGN KEY (`poiId`) REFERENCES
Given the error #1005 and some googling I ran into this post:
http://verysimple.com/2006/10/22/mysql-error-number-1005-cant-create-table-mydbsql-328_45frm-errno-150/
Based on what I read here I made some minor changes. Please try this
SQL.
Keep us posted!
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
CREATE TABLE IF NOT EXISTS `action` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uri` varchar(1024) DEFAULT NULL,
`label` varchar(255) DEFAULT NULL,
`poiId` int(11) NOT NULL,
`contentType` varchar(255) DEFAULT NULL,
`method` varchar(50) DEFAULT NULL,
`activityType` int(11) DEFAULT NULL,
`params` varchar(1024) DEFAULT NULL,
`closeBiw` tinyint(1) DEFAULT '0',
`showActivity` tinyint(1) DEFAULT '1',
`activityMessage` varchar(255) DEFAULT NULL,
`autoTrigger` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Can
ONLY be used with feature tracked images',
`autoTriggerRange` int(11) DEFAULT NULL,
`autoTriggerOnly` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `poiId` (`poiId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `animation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`poiId` int(11) NOT NULL,
`event` varchar(50) NOT NULL,
`type` varchar(50) NOT NULL,
`length` int(11) NOT NULL,
`delay` int(11) DEFAULT NULL,
`type` varchar(50) NOT NULL,
`length` int(11) NOT NULL,
`interpolation` varchar(50) DEFAULT NULL,
`interpolationParam` double DEFAULT NULL,
`persist` tinyint(1) DEFAULT '0',
`repeat` tinyint(1) DEFAULT '0',
`from` double DEFAULT NULL,
`to` double DEFAULT NULL,
`axis` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `poiId` (`poiId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `layer` (
`layer` varchar(255) DEFAULT NULL,
`refreshInterval` int(11) DEFAULT '300',
`refreshDistance` int(11) DEFAULT '100',
`fullRefresh` tinyint(1) DEFAULT '1',
`showMessage` varchar(1024) DEFAULT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
`biwStyle` varchar(9) DEFAULT NULL,
`disableClueMenu` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
CREATE TABLE IF NOT EXISTS `poi` (
`biwStyle` varchar(9) DEFAULT NULL,
`doNotIndex` tinyint(1) unsigned DEFAULT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
`imageURL` varchar(1024) DEFAULT NULL,
`layerID` int(11) DEFAULT NULL,
`showBiwOnClick` tinyint(1) unsigned DEFAULT '1',
`showSmallBiw` tinyint(1) unsigned DEFAULT '1',
`anchor_geolocation_alt` float DEFAULT NULL,
`anchor_geolocation_lat` double DEFAULT NULL,
`anchor_geolocation_lon` double DEFAULT NULL,
`anchor_referenceImage` varchar(64) CHARACTER SET ascii DEFAULT
NULL,
`icon_type` int(4) DEFAULT NULL,
`icon_url` varchar(128) DEFAULT NULL COMMENT 'Use either an
icon_type or an icon_url. Both makes no sense',
`object_contentType` varchar(64) DEFAULT NULL,
`object_reducedURL` varchar(255) DEFAULT NULL,
`object_size` float DEFAULT NULL,
`object_url` varchar(255) CHARACTER SET ascii DEFAULT NULL,
`text_description` text CHARACTER SET utf8,
`text_footnote` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`text_title` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`transform_rotate_angle` int(11) DEFAULT NULL,
`transform_rotate_axis_x` float unsigned DEFAULT '0',
`transform_rotate_axis_y` float unsigned DEFAULT '0',
`transform_rotate_axis_z` float unsigned DEFAULT '0',
`transform_rotate_rel` tinyint(1) DEFAULT NULL,
`transform_scale` float DEFAULT NULL,
`transform_translate_x` float unsigned DEFAULT '0',
`transform_translate_y` float unsigned DEFAULT '0',
`transform_translate_z` float unsigned DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
ALTER TABLE `action`
ADD CONSTRAINT `Action_ibfk_1` FOREIGN KEY (`poiId`) REFERENCES
`poi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `animation`
`poi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
ADD CONSTRAINT `Animation_ibfk_1` FOREIGN KEY (`poiId`) REFERENCES
Nico Knoester
Sep 14, 2011, 4:10:11 AM9/14/11
to PorPOISe
Hi Menno,
Started from scratch and imported the SQL:
I now get a slightly different error message:
SQLSTATE[42S02]: Base table or view not found: 1146 Table
'my_databasename.Layer' doesn't exist
instead of the error message that was shown before:
Database error: SQLSTATE[42S02]: Base table or view not found: 1146
Table 'my_databasename.layer' doesn't exist
In the dashboard i am not able to click on my layar name and get a
next screen with the possibility to add pois (like before), it
directly shows the error above.
> Given the error #1005 and some googling I ran into this post:http://verysimple.com/2006/10/22/mysql-error-number-1005-cant-create-...
Started from scratch and imported the SQL:
I now get a slightly different error message:
SQLSTATE[42S02]: Base table or view not found: 1146 Table
instead of the error message that was shown before:
Database error: SQLSTATE[42S02]: Base table or view not found: 1146
Table 'my_databasename.layer' doesn't exist
next screen with the possibility to add pois (like before), it
directly shows the error above.
> Given the error #1005 and some googling I ran into this post:http://verysimple.com/2006/10/22/mysql-error-number-1005-cant-create-...
Reply all
Reply to author
Forward
0 new messages