Tips om te instaleren

Slimbout · Bericht door **Slimbout** » 09 jun 2005, 18:01

Hey ik wil de cashmod instaleren, wat moet ik doen om te voorkomen dat het fout gaat? dat is al zo vaak gebeurt, dat wil ik niet nog een keer, zeker omdat ik nu 111 members heb

svenn · Bericht door **svenn** » 09 jun 2005, 18:02

backupp nemen van al je bestanden die je gaat editen , en backup van je mysql tabel ...

Trinithy · Bericht door **Trinithy** » 09 jun 2005, 18:16

wat maakt het uit

Heel erg actief zijn je members niet

ja psies, ik zou ook een backup nemen. Dan behou je alle posts (tog?!) en alle members

Slimbout · Bericht door **Slimbout** » 10 jun 2005, 15:28

Die site is me sig is oud, dit is de nieuwe

http://www.hiphopkings.nl

Slimbout · Bericht door **Slimbout** » 11 jun 2005, 10:42

Bedankt voor de tips, ik ga nu aan de slag

Als ik problemen krijg dan zeg ik het hier wel

Slimbout · Bericht door **Slimbout** » 11 jun 2005, 11:38

Ik heb alles gedaan, alleen nog de sql, maar dat mislukt

ik heb sql_install.php erin gezet en ben ernaar toe gegaan

maar dan krijg je dit

Code: Selecteer alles

Fatal error: Call to undefined function: message_die() in /home/virtual/site59/fst/var/www/html/sql_install.php on line 33

Wat moet ik doen?

alvast bedankt

Bee · Bericht door **Bee** » 11 jun 2005, 11:52

Geef de eerste 30 regels van het bestand eens.

Slimbout · Bericht door **Slimbout** » 11 jun 2005, 12:09

Code: Selecteer alles

<?php 
/*************************************************************************** 
 *                              sql_install.php 
 *                            -------------------
 *   begin                : Thursday, Apr 17, 2003
 *   copyright            : (C) 2003 Xore
 *   email                : mods@xore.ca
 *
 *   $Id: sql_install.php,v 2.2.0.0 2003/10/18 00:49:26 Xore $
 *
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', true); 
$phpbb_root_path = './'; 

$i = 0;
while ( !file_exists($phpbb_root_path . 'extension.inc') && ($i++ < 4) )
{
	$phpbb_root_path .= '../';
}
if ( $i > 4 )
{
   message_die(GENERAL_MESSAGE, 'Unable to find extension.inc, terminating. Please move this file into your main/"root" phpbb directory and try again.'); 
}

include($phpbb_root_path . 'extension.inc'); 
include($phpbb_root_path . 'common.'.$phpEx); 

// 
// Start session management 
// 
$userdata = session_pagestart($user_ip, PAGE_INDEX); 
init_userprefs($userdata); 
// 
// End session management 
// 

if( !$userdata['session_logged_in'] ) 
{ 
	redirect(append_sid("login.$phpEx?redirect=sql_install.$phpEx", true));
} 

if( $userdata['user_level'] != ADMIN ) 
{ 
   message_die(GENERAL_MESSAGE, 'You are not authorised to access this page'); 
} 

$page_title = 'Installing Cash Mod v 2.2.2 Tables, Updating Configuration settings'; 
include($phpbb_root_path . 'includes/page_header.'.$phpEx); 

print<<<DELIM
<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">
  <tr>
    <th class="thHead">Updating the database</th>
  </tr>
  <tr>
    <td>
      <span class="genmed">
        <ul type="circle">

DELIM;

$current_time = time();

switch ( SQL_LAYER )
{
	case 'msaccess':
	break;
	case 'postgresql':
	break;
	case 'mssql':
	case 'mssql-odbc':
      $sql = array( 
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable',0);",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_display_after_posts',1);",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_post_message','You earned %s for that post');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable_spam_num',10);",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable_spam_time',24);",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable_spam_message','You have exceeded the alloted amount of posts and will not earn anything for your post');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_installed','yes');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_version','2.2.2');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('points_name','Points');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_adminnavbar','1');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_adminbig','0');",


		   "CREATE TABLE [userid].[{$table_prefix}cash] (
			[cash_id] [int] IDENTITY (1, 1) NOT NULL,
			[cash_order] [int] NOT NULL,
			[cash_settings] [int] NOT NULL,
			[cash_dbfield] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
			[cash_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
			[cash_default] [int] NOT NULL,
			[cash_decimals] [int] NOT NULL,
			[cash_imageurl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
			[cash_exchange] [int] NOT NULL,
			[cash_perpost] [int] NOT NULL,
			[cash_postbonus] [int] NOT NULL,
			[cash_perreply] [int] NOT NULL,
			[cash_maxearn] [int] NOT NULL,
			[cash_perpm] [int] NOT NULL,
			[cash_perchar] [int] NOT NULL,
			[cash_allowance] [int] NOT NULL,
			[cash_allowanceamount] [int] NOT NULL,
			[cash_allowancetime] [int] NOT NULL,
			[cash_allowancenext] [int] NOT NULL,
			[cash_forumlist] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
			) ON [PRIMARY]",
		   "ALTER TABLE [userid].[{$table_prefix}cash] WITH NOCHECK ADD 
			CONSTRAINT [PK_{$table_prefix}cash] PRIMARY KEY CLUSTERED 
			( 
			[cash_id] 
			) ON [PRIMARY]", 
		   "ALTER TABLE [userid].[{$table_prefix}cash] WITH NOCHECK ADD 
			CONSTRAINT [DF_{$table_prefix}cash_cash_order]           DEFAULT (0) FOR [cash_order], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_settings]        DEFAULT (3313) FOR [cash_settings], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_dbfield]         DEFAULT ('user_cash') FOR [cash_dbfield], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_name]            DEFAULT ('cash') FOR [cash_name], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_default]         DEFAULT (0) FOR [cash_default], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_decimals]        DEFAULT (0) FOR [cash_decimals], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_imageurl]        DEFAULT (' ') FOR [cash_imageurl], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_exchange]        DEFAULT (1) FOR [cash_exchange], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_perpost]         DEFAULT (25) FOR [cash_perpost], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_postbonus]       DEFAULT (2) FOR [cash_postbonus], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_perreply]        DEFAULT (25) FOR [cash_perreply], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_maxearn]         DEFAULT (75) FOR [cash_maxearn], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_perpm]           DEFAULT (0) FOR [cash_perpm], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_perchar]         DEFAULT (20) FOR [cash_perchar], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_allowance]       DEFAULT (0) FOR [cash_allowance], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_allowanceamount] DEFAULT (0) FOR [cash_allowanceamount], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_allowancetime]   DEFAULT (2) FOR [cash_allowancetime], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_allowancenext]   DEFAULT (0) FOR [cash_allowancenext], 
			CONSTRAINT [DF_{$table_prefix}cash_cash_forumlist]       DEFAULT (' ') FOR [cash_forumlist]", 


		   "CREATE TABLE [userid].[{$table_prefix}cash_events] (
			[event_name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
			[event_data] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
			) ON [PRIMARY]",
		   "ALTER TABLE [userid].[{$table_prefix}cash_events] WITH NOCHECK ADD 
			CONSTRAINT [PK_{$table_prefix}cash_events] PRIMARY KEY CLUSTERED 
			( 
			[event_name] 
			) ON [PRIMARY]", 
		   "ALTER TABLE [userid].[{$table_prefix}cash_events] WITH NOCHECK ADD 
			CONSTRAINT [DF_{$table_prefix}cash_events_event_name]    DEFAULT (' ') FOR [event_name], 
			CONSTRAINT [DF_{$table_prefix}cash_events_event_data]    DEFAULT (' ') FOR [event_data]", 


		   "CREATE TABLE [userid].[{$table_prefix}cash_exchange] ( 
			[ex_cash_id1] [int] NOT NULL , 
			[ex_cash_id2] [int] NOT NULL , 
			[ex_cash_enabled] [int] NOT NULL 
			) ON [PRIMARY]", 
		   "ALTER TABLE [userid].[{$table_prefix}cash_exchange] WITH NOCHECK ADD 
			CONSTRAINT [PK_{$table_prefix}cash_exchange] PRIMARY KEY CLUSTERED 
			( 
			[ex_cash_id1], 
			[ex_cash_id2] 
			) ON [PRIMARY]", 
		   "ALTER TABLE [userid].[{$table_prefix}cash_exchange] WITH NOCHECK ADD 
			CONSTRAINT [DF_{$table_prefix}cash_exchange_cash_enabled] DEFAULT (1) FOR [ex_cash_enabled]",


		   "CREATE TABLE [userid].[{$table_prefix}cash_groups] (
			[group_id] [int] NOT NULL,
			[group_type] [int] NOT NULL,
			[cash_id] [int] NOT NULL,
			[cash_perpost] [int] NOT NULL,
			[cash_postbonus] [int] NOT NULL,
			[cash_perreply] [int] NOT NULL,
			[cash_perchar] [int] NOT NULL,
			[cash_maxearn] [int] NOT NULL,
			[cash_perpm] [int] NOT NULL,
			[cash_allowance] [int] NOT NULL,
			[cash_allowanceamount] [int] NOT NULL,
			[cash_allowancetime] [int] NOT NULL,
			[cash_allowancenext] [int] NOT NULL,
			) ON [PRIMARY]", 
		   "ALTER TABLE [userid].[{$table_prefix}cash_groups] WITH NOCHECK ADD 
			CONSTRAINT [PK_{$table_prefix}cash_groups] PRIMARY KEY CLUSTERED 
			( 
			[group_id],[group_type],[cash_id] 
			) ON [PRIMARY]", 
		   "ALTER TABLE [userid].[{$table_prefix}cash_groups] WITH NOCHECK ADD 
			CONSTRAINT [DF_{$table_prefix}cash_groups_cash_perpost]         DEFAULT (0) FOR [cash_perpost], 
			CONSTRAINT [DF_{$table_prefix}cash_groups_cash_postbonus]       DEFAULT (0) FOR [cash_postbonus], 
			CONSTRAINT [DF_{$table_prefix}cash_groups_cash_perreply]        DEFAULT (0) FOR [cash_perreply], 
			CONSTRAINT [DF_{$table_prefix}cash_groups_cash_perchar]         DEFAULT (0) FOR [cash_perchar], 
			CONSTRAINT [DF_{$table_prefix}cash_groups_cash_maxearn]         DEFAULT (0) FOR [cash_maxearn], 
			CONSTRAINT [DF_{$table_prefix}cash_groups_cash_perpm]           DEFAULT (0) FOR [cash_perpm], 
			CONSTRAINT [DF_{$table_prefix}cash_groups_cash_allowance]       DEFAULT (0) FOR [cash_allowance], 
			CONSTRAINT [DF_{$table_prefix}cash_groups_cash_allowanceamount] DEFAULT (0) FOR [cash_allowanceamount], 
			CONSTRAINT [DF_{$table_prefix}cash_groups_cash_allowancetime]   DEFAULT (2) FOR [cash_allowancetime], 
			CONSTRAINT [DF_{$table_prefix}cash_groups_cash_allowancenext]   DEFAULT (0) FOR [cash_allowancenext]", 


		   "CREATE TABLE [userid].[{$table_prefix}cash_log] (
			log_id [int] IDENTITY (1, 1) NOT NULL,
			log_time [int] NOT NULL,
			log_type [int] NOT NULL,
			log_action [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
			log_text [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
			) ON [PRIMARY]", 
		   "ALTER TABLE [userid].[{$table_prefix}cash_log] WITH NOCHECK ADD 
			CONSTRAINT [PK_{$table_prefix}cash_log] PRIMARY KEY CLUSTERED 
			( 
			[log_id] 
			) ON [PRIMARY]", 
		   "ALTER TABLE [userid].[{$table_prefix}cash_log] WITH NOCHECK ADD 
			CONSTRAINT [DF_{$table_prefix}cash_log_log_time]   DEFAULT (0) FOR [log_time], 
			CONSTRAINT [DF_{$table_prefix}cash_log_log_type]   DEFAULT (0) FOR [log_type], 
			CONSTRAINT [DF_{$table_prefix}cash_log_log_action] DEFAULT (' ') FOR [log_action], 
			CONSTRAINT [DF_{$table_prefix}cash_log_log_text]   DEFAULT (' ') FOR [log_text]" 
		);
	break;
	case 'mysql':
	case 'mysql4':
	default:
		$sql = array(
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable',0);",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_display_after_posts',1);",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_post_message','You earned %s for that post');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable_spam_num',10);",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable_spam_time',24);",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_disable_spam_message','You have exceeded the alloted amount of posts and will not earn anything for your post');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_installed','yes');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_version','2.2.2');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('points_name','Points');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_adminnavbar','1');",
		   "INSERT INTO {$table_prefix}config (config_name, config_value) VALUES ('cash_adminbig','0');",

		   "CREATE TABLE {$table_prefix}cash (
			cash_id smallint(6) NOT NULL auto_increment,
			cash_order smallint(6) NOT NULL default '0',
			cash_settings smallint(4) NOT NULL default '3313',
			cash_dbfield varchar(64) NOT NULL default 'user_cash',
			cash_name varchar(64) NOT NULL default 'cash',
			cash_default int(11) NOT NULL default '0',
			cash_decimals tinyint(2) NOT NULL default '0',
			cash_imageurl varchar(255) NOT NULL default ' ',
			cash_exchange int(11) NOT NULL default '1',
			cash_perpost int(11) NOT NULL default '25',
			cash_postbonus int(11) NOT NULL default '2',
			cash_perreply int(11) NOT NULL default '25',
			cash_maxearn int(11) NOT NULL default '75',
			cash_perpm int(11) NOT NULL default '0',
			cash_perchar int(11) NOT NULL default '20',
			cash_allowance tinyint(1) NOT NULL default '0',
			cash_allowanceamount int(11) NOT NULL default '0',
			cash_allowancetime tinyint(2) NOT NULL default '2',
			cash_allowancenext int(11) NOT NULL default '0',
			cash_forumlist varchar(255) NOT NULL default ' ',
			PRIMARY KEY  (cash_id)
			);",

		   "CREATE TABLE {$table_prefix}cash_events (
			event_name varchar(32) NOT NULL default ' ',
			event_data varchar(255) NOT NULL default ' ',
			PRIMARY KEY  (event_name)
			);",

		   "CREATE TABLE {$table_prefix}cash_exchange (
			ex_cash_id1 int(11) NOT NULL default '0',
			ex_cash_id2 int(11) NOT NULL default '0',
			ex_cash_enabled int(1) NOT NULL default '0',
			PRIMARY KEY  (ex_cash_id1,ex_cash_id2)
			);",

		   "CREATE TABLE {$table_prefix}cash_groups (
			group_id mediumint(6) NOT NULL default '0',
			group_type tinyint(2) NOT NULL default '0',
			cash_id smallint(6) NOT NULL default '0',
			cash_perpost int(11) NOT NULL default '0',
			cash_postbonus int(11) NOT NULL default '0',
			cash_perreply int(11) NOT NULL default '0',
			cash_perchar int(11) NOT NULL default '0',
			cash_maxearn int(11) NOT NULL default '0',
			cash_perpm int(11) NOT NULL default '0',
			cash_allowance tinyint(1) NOT NULL default '0',
			cash_allowanceamount int(11) NOT NULL default '0',
			cash_allowancetime tinyint(2) NOT NULL default '2',
			cash_allowancenext int(11) NOT NULL default '0',
			PRIMARY KEY  (group_id,group_type,cash_id)
			);",

		   "CREATE TABLE {$table_prefix}cash_log (
			log_id int(11) NOT NULL auto_increment,
			log_time int(11) NOT NULL default '0',
			log_type smallint(6) NOT NULL default '0',
			log_action varchar(255) NOT NULL default ' ',
			log_text varchar(255) NOT NULL default ' ',
			PRIMARY KEY  (log_id)
			);"
		);
	break;
}

foreach ( $sql AS $query ) 
{ 
   if ( !($result = $db->sql_query($query)) )
   { 
      $error = $db->sql_error();
      print('<li>' . nl2br($query) . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />');
   } 
   else 
   { 
      print('<li>' . nl2br($query) . '<br /> +++ <font color="#00AA00"><b>Successfull</b></font></li><br />');
   } 
}

$forum_url = append_sid($phpbb_root_path . "index.$phpEx");
$phpbb_url = "http://www.phpbb.com/phpBB/viewtopic.php?t=94055#623226";

print<<<DELIM
        </ul>
      </span>
    </td>
  </tr>
  <tr>
    <td class="catBottom" height="28">&nbsp;</td>
  </tr>
  <tr>
    <td class="catBottom" colspan="2" align="center">Finished</td>
  </tr>
</table>

<br />
<br />

<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">
  <tr>
    <th class="thHead">SQL Installation complete</th>
  </tr>
  <tr>
    <td>
      <span class="genmed">Please delete this file (sql_install.{$phpEx}).<br />
      If you have any problems, please visit <a href="{$phpbb_url}" target="_new">phpbb.com (CashMod v 2.2.2 Support Thread)</a> and ask for help.</span>
    </td>
  </tr>
  <tr>
    <td class="catBottom" height="28" align="center">
      <span class="genmed"><a href="{$forum_url}">Click Here to return to your forum.</a>
      </span>
    </td>
  </tr>
</table>

DELIM;

include($phpbb_root_path . 'includes/page_tail.'.$phpEx); 

?>

Dit is heel het bestand, bedankt dat je me helpt

Luuk · Bericht door **Luuk** » 11 jun 2005, 12:42

Haal dit eens weg uit het bestand

Code: Selecteer alles

$i = 0;
while ( !file_exists($phpbb_root_path . 'extension.inc') && ($i++ < 4) )
{
   $phpbb_root_path .= '../';
}
if ( $i > 4 )
{
   message_die(GENERAL_MESSAGE, 'Unable to find extension.inc, terminating. Please move this file into your main/"root" phpbb directory and try again.');
}

Slimbout · Bericht door **Slimbout** » 11 jun 2005, 13:02

Nu staat er dit:

Code: Selecteer alles

Warning: main(): Unable to access ./extension.inc in /home/virtual/site59/fst/var/www/html/sql_install.php on line 28

Warning: main(./extension.inc): failed to open stream: No such file or directory in /home/virtual/site59/fst/var/www/html/sql_install.php on line 28

Warning: main(): Unable to access ./extension.inc in /home/virtual/site59/fst/var/www/html/sql_install.php on line 28

Warning: main(./extension.inc): failed to open stream: No such file or directory in /home/virtual/site59/fst/var/www/html/sql_install.php on line 28

Warning: main(): Failed opening './extension.inc' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site59/fst/var/www/html/sql_install.php on line 28

Warning: main(): Unable to access ./common. in /home/virtual/site59/fst/var/www/html/sql_install.php on line 29

Warning: main(./common.): failed to open stream: No such file or directory in /home/virtual/site59/fst/var/www/html/sql_install.php on line 29

Warning: main(): Unable to access ./common. in /home/virtual/site59/fst/var/www/html/sql_install.php on line 29

Warning: main(./common.): failed to open stream: No such file or directory in /home/virtual/site59/fst/var/www/html/sql_install.php on line 29

Warning: main(): Failed opening './common.' for inclusion (include_path='.:/php/includes:/usr/share/php') in /home/virtual/site59/fst/var/www/html/sql_install.php on line 29

Fatal error: Call to undefined function: session_pagestart() in /home/virtual/site59/fst/var/www/html/sql_install.php on line 34

Bee · Bericht door **Bee** » 11 jun 2005, 14:00

Je moet hem in de forum map zetten

Slimbout · Bericht door **Slimbout** » 11 jun 2005, 16:11

Het is gelukt

domme fout

Heel erg bedankt, ik wil je site wel linken op http://www.hiphopkings.nl
Heb best veel bezoekers

Slimbout · Bericht door **Slimbout** » 11 jun 2005, 16:29

Weer iets

Als ik een currencie aanmaak komt er dit te staan

Code: Selecteer alles

phpBB : Critical Error 

Unable to insert new record into cash table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 's','user_money',1,0)' at line 3

INSERT INTO cash (cash_name, cash_dbfield, cash_order, cash_decimals) VALUES ('Doekoe's','user_money',1,0)

Line : 376
File : /home/virtual/site59/fst/var/www/html/forum/admin/cash_currencies.php

Moet ik de sql handmatig doen?

Bericht door **Paul** » 11 jun 2005, 16:53

je mag geen ' er in hebben zitten

Slimbout · Bericht door **Slimbout** » 11 jun 2005, 19:03

paulus schreef:je mag geen ' er in hebben zitten

Hoe bedoel je?

Bericht door **Paul** » 11 jun 2005, 19:05

dat het teken ' niet in de naam of veldnaam mag zitten

Slimbout · Bericht door **Slimbout** » 11 jun 2005, 20:35

Ik heb geen ' erin staan

Bericht door **Paul** » 11 jun 2005, 20:36

INSERT INTO cash (cash_name, cash_dbfield, cash_order, cash_decimals) VALUES ('Doekoe's','user_money',1,0)

dat had je wel, als naam ervoor

Slimbout · Bericht door **Slimbout** » 11 jun 2005, 22:28

Ooh zo, toch wel

sorry

Slimbout · Bericht door **Slimbout** » 11 jun 2005, 22:29

MAar ik krijg nog steeds dezelfde error

Code: Selecteer alles

phpBB : Critical Error 

Could not update user table (possibly duplicate cash db field)

DEBUG MODE

SQL Error : 1060 Duplicate column name 'user_doekoe'

ALTER TABLE users ADD user_doekoe DECIMAL(11,0) NOT NULL DEFAULT '5'

Line : 352
File : /home/virtual/site59/fst/var/www/html/forum/admin/cash_currencies.php