Cake PHP (Bug even still exists in cake php2)
Bad programming by cake php here. This bug still exists in version 2. Why does it rely on a css file existing? A lot of people will alter the default template first (removing the default cake stuff), then when they revisit the home page, this error shows incorrectly. There should be a php conditional around this rather than assuming a css file has been included which may or may not be there. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: CakePhp related domain
On 11/11/11 18:33, "mike karthauser" wrote: > If this is the case then why not offer the domain at a nominal price - ie 20 > dollars rather than 200? If your intention is to keep it away from the domain > squatters then passing it on to someone to use it is worth that. Otherwise let > it expire and I'll grab it then :) > > Incidentally, as a developer who has benefitted from the work of the cakephp > foundation, perhaps donating it and some cash is more in order? +1 A little gratitude may the correct action in this case rather than legal wranglings or trying to grift $200... Cheers, Phil... -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Problem with default.ctp
I created a sample app using the scaffolding, which worked very well, thank you. I went the next step and created a default.ctp file using the one that comes with cakephp. I then created a style.css file with the following: * { font-family: "Lucida Grande",Lucida,sans-serif; } th { font-size: 14px; fond-weight: bold; background-color: #e1e1e1; border-bottom: 1px solid #ccc; padding: 10px; } div.actions ul { list-style-type: none; } I then tried rerunning the application and the only output I got was: css('styles');?> -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Trying to get phpFlickr working as a Vendor
Not sure if this is the correct way to reply, but I can't find the thread on the Google Groups site. I fixed the problem by trial and error by changing the 'phpFlickr' argument in App::import to lowercase. That was it! Works now. Just to clarify the new declaration is: App::import('Vendor', 'phpflickr'); (The file name itself is still 'phpFlickr.php') On 15 September 2010 22:55, igniteflow wrote: > Hi, I've had success with Vendors before, but can't seem to get this > example working, any help would be much appreciated. > > In my controller (flickr_controller.php) I have > > App::import('Vendor', 'phpFlickr'); // phpFlickr.php is in /app/ > vendors/phpFlickr.php > > class FlickrController extends AppController { > >var $name = 'Flickr'; >var $uses = array(); > >function index() { >$api_key = 'xxx'; >$secret = 'xxx'; >$flickr = new phpFlickr($api_key, $secret); >debug($flickr); >} > } > > The browser returns: > Fatal error: Class 'PhpFlickr' not found in /Applications/MAMP/htdocs/ > CakeApp/app/controllers/flickr_controller.php on line 15 > > I'm using CakePHP 1.3, the Facebook Api works using the same Vendor > import structure so I'm stumped why phpFlickr doesn't, especially as > it works fine from localhost outside of CakePHP. > > Any ideas? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Re: Using html5 video tag.
Thanks for the answer but it didn't worked. If i use the $html->tag: echo $html->tag('video','your browser does not support the video tag', array('src' => '/1.ogv', 'controls' => 'controls')); , I still have the same behaviour. I see the player in the browser but can't play de movie. The route is correct because if i make right click on the player and then click on save as... i download the video correctly. It's very strange because if i make a look to the generated source code and I copy it into a normal html file outside cakephp it works. On 30 abr, 05:58, tristan_ph wrote: > You may use HtmlHelper->tag() > > $this->Html->tag(__('your browser does not support the video tag', > true), array('src' => '/video.ogv', array('controls' => 'controls')); > > On Apr 29, 10:03 pm, Phil wrote: > > > > > Hi! > > > I'm trying to add a video file into my cakephp project using the html5 > > tag. If i write a simple html file with this code: > > > > > your browser does not support the video tag > > > > > If works properly in firefox. But if I try to the next code to my .ctp > > file in cakephp, firefox shows the player but is not playing the > > video: > > > > > your browser does not support the video tag > > > > > The video.ogv is in the webroot folder. > > > Thanks. > > > Check out the new CakePHP Questions sitehttp://cakeqs.organdhelp others > > with their CakePHP related questions. > > > You received this message because you are subscribed to the Google Groups > > "CakePHP" group. > > To post to this group, send email to cake-php@googlegroups.com > > To unsubscribe from this group, send email to > > cake-php+unsubscr...@googlegroups.com For more options, visit this group > > athttp://groups.google.com/group/cake-php?hl=en > > Check out the new CakePHP Questions sitehttp://cakeqs.organd help others with > their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group > athttp://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Using html5 video tag.
Hi! I'm trying to add a video file into my cakephp project using the html5 tag. If i write a simple html file with this code: your browser does not support the video tag If works properly in firefox. But if I try to the next code to my .ctp file in cakephp, firefox shows the player but is not playing the video: your browser does not support the video tag The video.ogv is in the webroot folder. Thanks. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
cookies / localhost / mac
I am using cakephp 1.2 on my mac. i cannot get $this->Cookie->write to actually write a cookie. i am guessing this has something to do with my localhost development environment, but I can't find any information on this issue. can someone help? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
Organization issues and more...
My questions aren't exactly about CakePHP, but more so around the MVC architecture. I couldn't find my particular answer through searching, but at least I discovered that this seems like an acceptable question here. I have a main menu. For each main menu item, there is a sub menu. To me, it made more sense that the URL would be // /, which would be /controller/action/. Because of this, I created a controller for each main menu item, and created actions in the appropriate controller for each sub menu item. My intents are for the user to click the main menu item, and the first sub menu item will be selected by default. As such, I used the index() for each controller to be the first (default) sub menu item. This is where I get confused though. The main menu item is simply for organizational purpose. It is almost as if I shouldn’t even have a controller for the main menu items, but rather, a controller for each sub menu item. I guess I would have to split my current database table up into multiple database tables, one for each controller (sub menu). I guess that also means one model for each controller as well. Does this make more sense? I have further issues, which go a bit further off topic but my main question is about MVC still. On each of these sub menu pages, the information from the database for the authorized user is displayed for the particular section they are on. I wanted to be able to edit this information by clicking on the text displayed and having it turn into a input box for editing. Then, when the user clicks away or presses enter, it turns back into normal text, without the input box. I can do this with Javascript just fine, but I don't know how this fits in with MVC. I guess I would just put it in my view and use it how I would without this framework, except input boxes will be created using the form helper? I really think I would prefer this method of editing over a separate edit page, but if you strongly disagree then constructive criticism is accepted. However, I'm still not entirely sure when the actual saving to the database should take place if I went about it this way. I was thinking it could commit the changes every time the text box turns back into normal text through AJAX, but depending on how many fields are being edited, that could be putting an unnecessary extra load on the server. I suppose it is a design decision I should be asking myself rather than people who are reading this that don't know any details of my project, but I am open for suggestions. The point was that I wanted the page to almost always have a presentation appearance and a bit more of an interactive feel to editing rather than switching entirely to an editing view. Congratulations to those of you who actually read everything. Thanks in advance for any help or insight. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: named params and prefix routing
Thanks for your idea - I just tried it, but interestingly, it doesn't work (i.e. the prefix is not set), but there's also no named parameter "prefix" appended to the url - it's completely ignored, as it seems. On 7 Jan., 18:55, brian wrote: > I've not used prefix routing myself but have you tried setting > 'prefix' in the link method? > > $html->link('alle Termine', array('controller' => $params > ['controller'], 'action' => 'entries', 'prefix' => 'intranet', 'future' => > '0')); > > On Wed, Jan 7, 2009 at 7:35 AM, Phil wrote: > > > Same problem here - these are my routes: > > > Router::connect('/intranet/', array('controller' => 'users', 'action' > > => 'index', 'prefix' => 'intranet', 'intranet' => true)); > > Router::connect('/intranet/:controller/:action/*', array('prefix' => > > 'intranet', 'intranet' => true)); > > > Works fine, except for creating a link with a named parameter: > > > $html->link('alle Termine', array('controller' => $params > > ['controller'], 'action' => 'entries', 'intranet'=>true, 'future' => > > '0')); > > > creates this link: > > > /calendar_entries/entries/intranet:1/future:1 > > > instead of: > > > /intranet/calendar_entries/entries/future:1 > > > Anything new about this problem here? > > > TIA, Phil > > > Marcelius schrieb: > >> I'm usually not the guy who bumbs postings but this problem still > >> exists... So my question is: is this behavior by design or am I doing > >> something wrong? > > >> On 12 dec, 07:53, Marcelius wrote: > >> > Thanks for the anwser but that didn't work here. > > >> > The be more clear: If I do not usenamedparams, the the url is > >> > correct: It has the prefix /owner > >> > If I do usenamedparams, the router adds owner:1 as anamedparam > >> > instead of prepending the /owner prefix. > > >> > So: > >> > Router::url(array("controller"=>"invoices", "action"=>"edit", 5, > >> > "owner"=>true, "key"=>"val")); > > >> > Returns and not expected: > >> > "/invoices/edit/5/owner:1/key:val" > >> > I would expect: > >> > "/owner/invoices/edit/5/key:val" > > >> > On 11 dec, 16:31, Lane wrote: > > >> > > What were you expecting the Router to return if not "/invoices/edit/5/ > >> > > owner:1/key:val"? > > >> > > On Dec 11, 4:39 am, Marcelius wrote: > > >> > > > Hello! > > >> > > > I have this route like the manual says for prefix routing: > > >> > > > Router::connect('/owner/:controller/:action/*', array > >> > > > ('prefix'=>'owner', 'owner'=>true)); > > >> > > > This works fine until I want to create a url with somenamedparamsin > >> > > > it: > > >> > > > Router::url(array("controller"=>"invoices", "action"=>"edit", 5, > >> > > > "owner"=>true)); > >> > > > returns "/owner/invoices/edit/5" as expected. > > >> > > > Router::url(array("controller"=>"invoices", "action"=>"edit", 5, > >> > > > "owner"=>true, "key"=>"val")); > >> > > > returns "/invoices/edit/5/owner:1/key:val" not as expected. > > >> > > > Something wrong in my routes? Please note that that's the only route > >> > > > available. > > >> > > > Thanks in advance! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: named params and prefix routing
Same problem here - these are my routes: Router::connect('/intranet/', array('controller' => 'users', 'action' => 'index', 'prefix' => 'intranet', 'intranet' => true)); Router::connect('/intranet/:controller/:action/*', array('prefix' => 'intranet', 'intranet' => true)); Works fine, except for creating a link with a named parameter: $html->link('alle Termine', array('controller' => $params ['controller'], 'action' => 'entries', 'intranet'=>true, 'future' => '0')); creates this link: /calendar_entries/entries/intranet:1/future:1 instead of: /intranet/calendar_entries/entries/future:1 Anything new about this problem here? TIA, Phil Marcelius schrieb: > I'm usually not the guy who bumbs postings but this problem still > exists... So my question is: is this behavior by design or am I doing > something wrong? > > On 12 dec, 07:53, Marcelius wrote: > > Thanks for the anwser but that didn't work here. > > > > The be more clear: If I do not usenamedparams, the the url is > > correct: It has the prefix /owner > > If I do usenamedparams, the router adds owner:1 as anamedparam > > instead of prepending the /owner prefix. > > > > So: > > Router::url(array("controller"=>"invoices", "action"=>"edit", 5, > > "owner"=>true, "key"=>"val")); > > > > Returns and not expected: > > "/invoices/edit/5/owner:1/key:val" > > I would expect: > > "/owner/invoices/edit/5/key:val" > > > > On 11 dec, 16:31, Lane wrote: > > > > > What were you expecting the Router to return if not "/invoices/edit/5/ > > > owner:1/key:val"? > > > > > On Dec 11, 4:39�am, Marcelius wrote: > > > > > > Hello! > > > > > > I have this route like the manual says for prefix routing: > > > > > > Router::connect('/owner/:controller/:action/*', array > > > > ('prefix'=>'owner', 'owner'=>true)); > > > > > > This works fine until I want to create a url with somenamedparamsin > > > > it: > > > > > > Router::url(array("controller"=>"invoices", "action"=>"edit", 5, > > > > "owner"=>true)); > > > > returns "/owner/invoices/edit/5" as expected. > > > > > > Router::url(array("controller"=>"invoices", "action"=>"edit", 5, > > > > "owner"=>true, "key"=>"val")); > > > > returns "/invoices/edit/5/owner:1/key:val" not as expected. > > > > > > Something wrong in my routes? Please note that that's the only route > > > > available. > > > > > > Thanks in advance! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: bake newbie problem with configuration
Now fixed, if its of any help to others :-) I created a new clean directory /webroot/cakephp instead of /webroot/ cake installed the latest nightly build copied the bits of my app across changes the sites-available for apache to reflect the above directory change ran bake as before all OK probably my fault on a previous upgrade of cakephp :-( On 2 Dec, 11:09, Phil <[EMAIL PROTECTED]> wrote: > Hi > I have a simple cakephp app working, now trying to usebake > downloaded 1.2 > installed php cli > > error message is > cannot redeclare class ClassRegistry in /webroot/cake/cake/libs > class_registry.php on line 39 > > I am using debian etch, php5, cakephp 1.2, postgresql > > I think its my configuration thats the cause, but am stuck > > any ideas please > CheersPhil --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: bake newbie problem with configuration
directories are /webroot/cake/app /webroot/cake/cake/console user phil from dir /webroot/cake/app calling ../cake/console/cake bake user PATH /usr/local/bin:/usr/bin:/bin:/usr/games 1.2.0.5875 pre-beta the response is ../cake/console/ Hello Phil Fatal Error: cannot redeclare class Class ClassRegistry etc On 2 Dec, 18:29, "Dardo Sordi Bogado" <[EMAIL PROTECTED]> wrote: > How are you calling it? > Are you using 1.2 prebeta, svn trunk/branch ? > What is your path? > > I've used it on debian and ubuntu, never had problems. > > 2007/12/2, Phil <[EMAIL PROTECTED]>: > > > > > Hi > > I have a simple cakephp app working, now trying to use bake > > downloaded 1.2 > > installed php cli > > > error message is > > cannot redeclare class ClassRegistry in /webroot/cake/cake/libs > > class_registry.php on line 39 > > > I am using debian etch, php5, cakephp 1.2, postgresql > > > I think its my configuration thats the cause, but am stuck > > > any ideas please > > Cheers > > Phil --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
bake newbie problem with configuration
Hi I have a simple cakephp app working, now trying to use bake downloaded 1.2 installed php cli error message is cannot redeclare class ClassRegistry in /webroot/cake/cake/libs class_registry.php on line 39 I am using debian etch, php5, cakephp 1.2, postgresql I think its my configuration thats the cause, but am stuck any ideas please Cheers Phil --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Newbie, slow response, wrong tools ?
More stuff to learn then, at least it is encouraging to know moving from msaccess is a good idea Thanks for the help phil On 29 Sep, 07:21, AD7six <[EMAIL PROTECTED]> wrote: > On Sep 28, 10:09 pm, Phil <[EMAIL PROTECTED]> wrote: > > > Newbie, slow response, wrong tools ? > > > I use ms access to run a small business and have decided to replace my > > app with > > linux, apache2, postgres 8., cakephp 1.2 > > > so far i have got as far as adapting the bookmarks tutorial by graham > > birdhttp://grahambird.co.uk/cake/tutorials/scaffolding.php > > > The problem is when I use it with 2500 records the response time is > > circa 100 secs > > Hi, > > > am I ? > > 1. displaying too big a data set > > Yes, but that won't account for 100seconds > > > 2. entirely in the wrong software with cakephp > > No, but there will be a number of things that you can do differently. > Stopping using msaccess was one such fantastic decision already > made :). > > > 3. should not be using scaffolding > > Scaffolding is there just for starting out, you would never use > scaffolding on a real site. > > > 4. made some error with the table or coding > > If you use bake, you will get editable code instead of getting cake to > generate a lot of logic on the fly all the time (see screencasts) > If you run with debug set to 0 cake caches some setup info. > If your tmp dir is not writable or missing, this is often a cause of > slow response > If you have any associations you could find you /think/ you are > looking and retrieved a small amount of data whereas infact you > retrieved a vast amount of data which you are not using. > > Once you have a simple application, if you then are still getting a > slow response identify at least where the time goes (use the log > function before and after a method you suspect, or use a profiling > tool) - 100s is obviously extremely slow. > > hth, > > AD --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Newbie, slow response, wrong tools ?
Will do, thanks for the suggestion On 29 Sep, 04:37, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi Phil, > > The problem isn't the amount of records, it's that you're trying to > display too many results on a single page at the same time. For this, > there is pagination. > > Read this on how to integrate pagination into your > app:http://bakery.cakephp.org/articles/view/advanced-pagination-1-2 > > Kevin, > > On Sep 28, 4:09 pm, Phil <[EMAIL PROTECTED]> wrote: > > > Newbie, slow response, wrong tools ? > > > I use ms access to run a small business and have decided to replace my > > app with > > linux, apache2, postgres 8., cakephp 1.2 > > > so far i have got as far as adapting the bookmarks tutorial by graham > > birdhttp://grahambird.co.uk/cake/tutorials/scaffolding.php > > > The problem is when I use it with 2500 records the response time is > > circa 100 secs > > > am I ? > > 1. displaying too big a data set > > 2. entirely in the wrong software with cakephp > > 3. should not be using scaffolding > > 4. made some error with the table or coding > > > the only odd thing I have done was to load the table without a > > primary key > > change ty_id to id and add created and modified > > > code and table below > > > tyre.php in models > > > class Tyre extends AppModel > > { > > var $name = 'Tyre';} > > > ?> > > > tyres_controller.php in controllers > > > class TyresController extends AppController > > { > > var $name = 'Tyres'; > > var $scaffold;} > > > ?> > > > -- add indexes later > > DROP TABLE tyres ; > > CREATE TABLE tyres ( > > --ty_ID SERIAL primary key, -- auto number field > > ty_product_code varchar(30), -- UNIQUE NOT NULL, > > ty_short_size integer DEFAULT 111 NOT NULL, > > ty_load integer NOT NULL, -- usually 2 digits > > ty_speedvarchar(2) NOT NULL , > > ty_desc varchar(35) NOT NULL > > ); > > Bulk load data > > > -- alter table > > ALTER TABLE tyres ADD column ty_ID SERIAL; > > -- add primary key > > ALTER TABLE tyres ADD PRIMARY KEY (ty_ID); > > > ALTER TABLE tyres RENAME COLUMN ty_ID to id; > > ALTER TABLE ADD COLUMN created TIMESTAMP; > > ALTER TABLE ADD COLUMN modified TIMESTAMP; --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Newbie, slow response, wrong tools ?
Newbie, slow response, wrong tools ? I use ms access to run a small business and have decided to replace my app with linux, apache2, postgres 8., cakephp 1.2 so far i have got as far as adapting the bookmarks tutorial by graham bird http://grahambird.co.uk/cake/tutorials/scaffolding.php The problem is when I use it with 2500 records the response time is circa 100 secs am I ? 1. displaying too big a data set 2. entirely in the wrong software with cakephp 3. should not be using scaffolding 4. made some error with the table or coding the only odd thing I have done was to load the table without a primary key change ty_id to id and add created and modified code and table below tyre.php in models tyres_controller.php in controllers -- add indexes later DROP TABLE tyres ; CREATE TABLE tyres ( --ty_ID SERIAL primary key, -- auto number field ty_product_code varchar(30), -- UNIQUE NOT NULL, ty_short_size integer DEFAULT 111 NOT NULL, ty_load integer NOT NULL, -- usually 2 digits ty_speedvarchar(2) NOT NULL , ty_desc varchar(35) NOT NULL ); Bulk load data -- alter table ALTER TABLE tyres ADD column ty_ID SERIAL; -- add primary key ALTER TABLE tyres ADD PRIMARY KEY (ty_ID); ALTER TABLE tyres RENAME COLUMN ty_ID to id; ALTER TABLE ADD COLUMN created TIMESTAMP; ALTER TABLE ADD COLUMN modified TIMESTAMP; --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---