| Previous topic :: Next topic |
| Author |
Message |
iLLin
Joined: 13 Jul 2006
Posts: 4
|
| Posted: Thu Jul 13, 2006 9:38 pm Post subject: Installion error while creating tables Step 5 |
|
|
I am installing this fresh on a linux box using oracle.
The error I get is this:
Creating Core tables: Error: Tables partially created. Table creation failed.
Going to index.php I get this:
Warning: Invalid argument supplied for foreach() in ..../httpdocs/index.php on line 541 (I'm sure due to the failure)
178 tables gets created in my tablespace. Is there a way to track where this fails so I can fix what's going on? Or anything I am overlooking? Any help I would appreciate it, thanks so much. |
|
| Back to top |
|
iLLin
Joined: 13 Jul 2006
Posts: 4
|
| Posted: Thu Jul 13, 2006 10:00 pm Post subject: Installion error while creating tables Step 5 |
|
|
An update: I fixed some typos in the db file (hmmm?) and setup the vtigercrm.log file.
Creating Core tables: ORA-00904: "POTENTIALFID": invalid identifier Error: Tables partially created. Table creation failed.
I actually get an error message now, and there are a lot of Query Failed in the log file.... I was under the impression this worked with Oracle? Am I doing something wrong?
Thanks |
|
| Back to top |
|
iLLin
Joined: 13 Jul 2006
Posts: 4
|
| Posted: Thu Jul 13, 2006 10:14 pm Post subject: Re: Installion error while creating tables Step 5 |
|
|
| I have attached my log file. IT seems its mostly seq and triggers not getting created. |
|
| Back to top |
|
Bushwack
Joined: 23 Aug 2005
Posts: 236
|
| Posted: Fri Jul 14, 2006 2:47 pm Post subject: Re: Installion error while creating tables Step 5 |
|
|
| I'd be surprised if you get vtiger to work with Oracle. You may have better luck with the latest code from the 4.2 SVN branch which supports postgres, so the SQL is a little more standard. |
|
| Back to top |
|
iLLin
Joined: 13 Jul 2006
Posts: 4
|
| Posted: Fri Jul 14, 2006 3:01 pm Post subject: Re: Installion error while creating tables Step 5 |
|
|
| Here's my dilema. I have a heavily modified sugarCRM that I need to upgrade to Oracle. Vtiger says they can use oracle and the codebase is sugars so I figured it would be easier to just transfer to vtiger and add all my mods that way. The SVN branch? Is this a break from sugar too? |
|
| Back to top |
|
Bushwack
Joined: 23 Aug 2005
Posts: 236
|
| Posted: Fri Jul 14, 2006 3:29 pm Post subject: Re: Installion error while creating tables Step 5 |
|
|
The code base isn't all that similar anymore. It's probably not all that easy to jump back and forth between programs.
I guess that once upon a time vtiger may have supported Oracle but as far as I know no one tests with it so I would expect a lot of problems.
I should note that I wouldn't deploy anything only available from SVN into production unless you know what your doing, as migration to updated versions is in no way guaranteed. |
|
| Back to top |
|
| |
