The Joomla! Forum ™

Download

Demo


Board index » Joomla! 2.5 - Ask Support Questions Here » Installation Joomla! 2.5 » Joomla! 2.5 on IIS webserver

Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 
  Print view Previous topic | Next topic 
Author Message
amisouli
PostPosted: Mon Feb 06, 2012 6:11 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Feb 06, 2012 6:08 pm
Posts: 1
Hi all,

i am trying to setup Joomla in Windows Server / MSSQL Express.
In step , configuring the database, i get this message:

Some errors occurred while populating the database: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "joomla_user_notes" because it does not exist or you do not have permissions.SQL=/****** Object: Default [DF__joomla_user___publi__308E3499] Script Date: 12/30/2011 16:12:16 ******/ IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[DF__joomla_user___publi__308E3499]') AND parent_object_id = OBJECT_ID(N'[joomla_user_notes]')) Begin IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__joomla_user___publi__308E3499]') AND type = 'D') BEGIN ALTER TABLE [joomla_user_notes] ADD DEFAULT (getdate()) FOR [publish_down] END End



I am checking in the DB and indeed i cannot find this table.
I AM STUCK

Any ideas are very welcome!

Thanks a lot
Regards
Aris


You do not have the required permissions to view the files attached to this post.

Top
 Profile  
 
snair692
PostPosted: Tue Feb 14, 2012 6:09 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Feb 14, 2012 6:07 pm
Posts: 2
Oddly enough I am having this exact same issue. What gives?
Top
 Profile  
 
snair692
PostPosted: Tue Feb 14, 2012 6:22 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Feb 14, 2012 6:07 pm
Posts: 2
There are all sorts of issues with the SQL Script that installs for 'SqlServer', the direct code has column data types as 'datetime2' which is not valid?

All sorts of precision (0) errors when trying to set precision to 0 on datetime2 type fields or even integer fields....

What the hekc? Is this made for MSSQL?
Top
 Profile  
 
Webdongle
PostPosted: Tue Feb 14, 2012 6:37 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Sat Apr 05, 2008 9:58 pm
Posts: 23362
Location: @Webdongle
#__user_notes is a Table in the 2.5 database. you have a prefix of joomla_ in your error.

What is the prefix of the other Tables ?

If not joomla_ then for some reason the install is using the wrong prefix.

But if your prefix is joomla_ then (during install) use the prefix that is already filled in the screen. And report back the results.

_________________
http://weblinksonline.co.uk/joomla-faq.html
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 


Board index » Joomla! 2.5 - Ask Support Questions Here » Installation Joomla! 2.5 » Joomla! 2.5 on IIS webserver

Who is online

Users browsing this forum: No registered users and 5 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group