Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Jun 26, 2009
  • Posts: 8

  Posted: Jun 07, 2005 - 11:23 AM

  I'm building a league module to track tournaments, and general league things like standings, ect. However, I'm having problems getting past my pinit.php file. I create the first six tables just fine, however I get
  

  Code

  _CREATETABLEFAILED: You have an error in your SQL syntax. Check the manual that corresponds to your mysql server version for the right syntax to use near 'Varchar(32) NOT NULL default '', nuke_leaguemanager_tsubmit

  
  When I reach that block, this is the code I have for that block, any suggestions? I've exhausted myself for the day. I also have problems removing that specific table from the database in postnuke.
  
  Here is a link to my pntables.php and pninit.php files
  http://www.gamingrep…s/leaguemanager.rar

  • 
  •  
• uheweb
  
  

  • Rank: Helper
  • Registered: Sep 16, 2004
  • Last visit: Oct 21, 2009
  • Posts: 731

  Posted: Jun 24, 2005 - 04:58 AM

  Your pntable file for $pntable['leaguemanager_tsubmitrace']; is wrong.
  
  In the pninit you create an SQL with $tsubmitracecolumn[sxtt] Varchar(32) NOT NULL default '',
  
  yet, the pntable has no definition for sxtt, there is a line for 'stht' => $leaguemanager_tsubmitrace . '.pn_stht',
  
  Also, there are two other entries undefined. Here is the SQL that MySQL recieved from your pninit and pntable initialization for this table:
  
  

  Code

  CREATE TABLE pn_leaguemanager_tsubmitrace(
  pn_leaguemanager_tsubmitrace.pn_sbrid int( 10 ) NOT null AUTO_INCREMENT ,
  pn_leaguemanager_tsubmitrace.pn_fst Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_scd Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_trd Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_fth Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_fvt Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_sth Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_svt Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_eth Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_fstt Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_scdt Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_trdt Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_ftht Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_fvtt Varchar( 32 ) NOT null default '',
  Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_svtt Varchar( 32 ) NOT null default '',
  Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_fsttl Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_scdtl Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_trdtl Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_fthtl Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_fvttl Varchar( 32 ) NOT null default '',
  Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_svttl Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_ethtl Varchar( 32 ) NOT null default '',
  pn_leaguemanager_tsubmitrace.pn_comments.TEXT NOT null default '',
  PRIMARY key ( pn_sbrid )
  )

  
  
  As you can see, there are three locations where its defining the column without a column name - meaning that the definition of that column in pntables is wrong or missing, or typod.
  
  Good luck...sounds like a great module Is it going to be release publically? Any idea when?
  
  Nolan M.
  UHEweb

  • 
  •  
•  
•  

Users on-line

• bronto,
• designerdogs

This list is based on users active over the last 60 minutes.