Installer MS SQL files

[Kamil Syed]

Is there a MS SQL install file to create db tables? The one contained in INSTALL/SQL does is MySQL specific.

 

Thanks.

[raulriera]

Hi Kamil,

Just head to the plugins section (below in the debug area) and click
on DbMigrate that will create your tables

[Kamil Syed]

I have completed steps 1 through 5. Stuck at #6: http://github.com/russjohnson/SplashCMS

 

My db has no tables yet. I cannot browse to /admin. I presume the plugins section is in the admin.

Thanks,

Kamil

[raulriera]

Odd,

Can you give this repo a try, skips that step

http://github.com/raulriera/SplashCMS

(self promotion! hehe)

On Oct 28, 11:01 pm, Kamil Syed <kamils...@gmail.com> wrote:
> I have completed steps 1 through 5. Stuck at #6:http://github.com/russjohnson/SplashCMS
>

> My db has *no tables* yet. I cannot browse to /admin. I presume the plugins

[Kamil Syed]

Can't reach http://yourwebroot/admin, which in my case is http://localhost/admin.

 

On http://localhost it says the following:

 

" Wheels.TableNotFound

The pages table could not be found in the database.

Suggested action

Add a table named pages to your database or tell Wheels to use a different table for this model. For example you can tell a user model to use a table called tbl_users by creating a User.cfc file in the models folder, creating an init method inside it and then calling table("tbl_users") from within it.

Error location

Line 13 in controllers\Viewer.cfc

11:         <cfparam name="params.slug" default="/">
12:     
13:         <cfset request.page = model('page').findOneBySlug(params.slug)>
14:     
15:         <cfif isObject(request.page) AND request.page.status is "published">

"

Thanks,

Kamil

[raulriera]

Do you have URL rewriting? if not you need to hit http://localhost/index.cfm/admin
(but splash is meant to work on full URL rewriting currently)



On Oct 28, 11:42 pm, Kamil Syed <kamils...@gmail.com> wrote:
> Can't reachhttp://yourwebroot/admin, which in my case ishttp://localhost/admin.

>
> Onhttp://localhostit says the following:
>
> " Wheels.TableNotFound
>

> *The pages table could not be found in the database.*

[Russ Johnson]

I have seen this issue come up several times since the SQL installer files were removed. I think we need start keeping an updated version in the install folder since there seem to be quite a few people trying out Splash that know nothing about Wheels.

- Russ

[Kamil Syed]

I dont have url rewriting enabled. Also upon trying http://localhost/index.cfm/admin and using admin/splash, it takes me to

http://localhost/index.cfm/admin/dologin and produces the following error:

 

The users table could not be found in the database.

Suggested action

Add a table named users to your database or tell Wheels to use a different table for this model. For example you can tell a user model to use a table called tbl_users by creating a User.cfc file in the models folder, creating an init method inside it and then calling table("tbl_users") from within it.

Error location

Line 32 in controllers\Sessions.cfc

Thanks,

Kamil

[Rob Parkhill]

in the bottom of the site, you will see the CFWheels debug area.  You will see the plugins listed, Click on DBMigrate plugin.

Choose the last item in the dropdown, as Migrate all never seemed to work for me, and click go

This will create/populate the data in your database for you.  No need for SQL statements!

Rob

[Kamil Syed]

Still doesn't work: after migration, I still can't get past this error "The pages table could not be found in the database."

 

I'm just going to give up :(

Thanks for  your help.

Kamil

[Russ Johnson]

This is why I say we need the SQL scripts. That DBMigrate plugin has NEVER worked for me.  Doesnt throw errors anymore, but it just doesnt create the tables and I have never been able to figure out why...

Im going to create the SQL scripts this weekend if I have time and add them back into the repo. I want to try and pull Rauls latest stuff into the official repo anyways so that will be a good time to package up a new release.

- Russ

[Indiver Nagpal]

I've been using DBMigrate plugin, but on MySQL. And it has worked well for me till now. In fact I was going to highlight that as part of a CFWheels talk I'm giving at CFObjective Australia in a couple of weeks!

But I agree... having scripts for the first-time install is a better idea. Having said that, the only reason why I started using Raul's repo was that it was much easier to have it up and going. I had tried it off the official repo but kept running into other issues.

The second hurdle I faced was rebuilding all layouts/snippets/pages. That just confused the matters. But once I got my head around it, it was easy.

I'm sharing this because I'm sure others are facing these issues as well.

[raulriera]

Yeah, an "install" UI would be nice

On Oct 29, 8:48 pm, Indiver Nagpal <indi...@nagpals.com> wrote:
> I've been using DBMigrate plugin, but on MySQL. And it has worked well for
> me till now. In fact I was going to highlight that as part of a CFWheels
> talk I'm giving at CFObjective Australia in a couple of weeks!
>
> But I agree... having scripts for the first-time install is a better idea.
> Having said that, the only reason why I started using Raul's repo was that
> it was much easier to have it up and going. I had tried it off the official
> repo but kept running into other issues.
>
> The second hurdle I faced was rebuilding all layouts/snippets/pages. That
> just confused the matters. But once I got my head around it, it was easy.
>
> I'm sharing this because I'm sure others are facing these issues as well.
>

> On Sat, Oct 30, 2010 at 6:58 AM, Russ Johnson <russ.cfco...@gmail.com>wrote:
>
>
>
> > This is why I say we need the SQL scripts. That DBMigrate plugin has NEVER
> > worked for me.  Doesnt throw errors anymore, but it just doesnt create the
> > tables and I have never been able to figure out why...
>
> > Im going to create the SQL scripts this weekend if I have time and add them
> > back into the repo. I want to try and pull Rauls latest stuff into the
> > official repo anyways so that will be a good time to package up a new
> > release.
>
> > - Russ
>
> > On Oct 29, 2010, at 12:19 PM, Kamil Syed wrote:
>

> > Still doesn't work: after migration, I still can't get past this error "*The

> > pages table could not be found in the database.*"
>

> > I'm just going to give up :(
> > Thanks for  your help.
>
> > Kamil
>

> > On Fri, Oct 29, 2010 at 10:53 AM, Rob Parkhill <robert.parkh...@gmail.com>wrote:
>
> >> in the bottom of the site, you will see the CFWheels debug area.  You will
> >> see the plugins listed, Click on DBMigrate plugin.
>
> >> Choose the last item in the dropdown, as Migrate all never seemed to work
> >> for me, and click go
>
> >> This will create/populate the data in your database for you.  No need for
> >> SQL statements!
>
> >> Rob
>

> >> On Fri, Oct 29, 2010 at 11:33 AM, Kamil Syed <kamils...@gmail.com> wrote:
>
> >>> I dont have url rewriting enabled. Also upon trying

> >>>http://localhost/index.cfm/adminand using admin/splash, it takes me to

> >>>http://localhost/index.cfm/admin/dologinand produces the following
> >>> error:
>

> >>> *The users table could not be found in the database.*
> >>> Suggested action
>

> >>> Add a table named users to your database or tell Wheels to use a
> >>> different table for this model. For example you can tell a user model to

> >>> use a table called tbl_users by creating a User.cfc file in the modelsfolder, creating an

> >>> init method inside it and then calling table("tbl_users") from within
> >>> it.
> >>> Error location
>
> >>> Line 32 in controllers\Sessions.cfc
>
> >>> Thanks,
>
> >>> Kamil
>

> >>> On Thu, Oct 28, 2010 at 5:07 PM, raulriera <rierar...@gmail.com> wrote:
>
> >>>> Do you have URL rewriting? if not you need to hit
> >>>>http://localhost/index.cfm/admin
> >>>> (but splash is meant to work on full URL rewriting currently)
>
> >>>> On Oct 28, 11:42 pm, Kamil Syed <kamils...@gmail.com> wrote:
> >>>> > Can't reachhttp://yourwebroot/admin, which in my case
> >>>> ishttp://localhost/admin.
>

> >>>> > Onhttp://localhostitsays the following: