Recordad que para pedir soporte alguno, debéis facilitar los datos de soporte oportunos por favor, mirad aquí y leer las Normas generales del foro, esto nos servirá de ayuda para dar el mejor soporte..

Gracias.

La Administración de phpBB España.

user remeinderTema Solucionado

Soporte de MODs para phpBB 3.0.x
Dudas sobre AutoMOD aquí por favor.
Cerrado
Nacho1191
Miembro
Mensajes: 246
Registrado: 11 Ene 2005, 07:25
Género:
Edad: 41

user remeinder

#1

Mensaje por Nacho1191 »

por una extraña razon despues de varios dias de haber instalado el mod user vote remeinder, ahora me salio este mensaje:
SQL ERROR [ mysqli ]

Unknown column 'user_vote_reminder' in 'field list' [1054]
el tema es que no puedo instalarlo por medio del install del mod, me gustaría que alguien me ayude y me diga como inyectar las instrucciones de manera manual.

este es el install del mod:

Código: Seleccionar todo

<?php
/**
*
* @author mtrs (mtrs) trst2007@gmail.com 
* @package umil
* @version $Id: install_vote_reminder.php, v1.0.0 2009/08/30 12:53:34 Exp $
* @copyright (c) 2009 mtrs 
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/


/**
* @ignore
*/
define('UMIL_AUTO', true);
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
$user->session_begin();
$auth->acl($user->data);
$user->setup();

if (!file_exists($phpbb_root_path . 'umil/umil_auto.' . $phpEx))
{
	trigger_error('Please download the latest UMIL (Unified MOD Install Library) from: <a href="http://www.phpbb.com/mods/umil/">phpBB.com/mods/umil</a>', E_USER_ERROR);
}

if (!isset($config['vote_reminder_enable']))
{
	$config['vote_reminder_enable'] = 0;
	$user->data['user_vote_reminder'] = 0;	
}

// The name of the mod to be displayed during installation.
$mod_name = 'POLL_VOTE_REMINDER';

/*
* The name of the config variable which will hold the currently installed version
* You do not need to set this yourself, UMIL will handle setting and updating the version itself.
*/
$version_config_name = 'vote_reminder_version';

$language_file = 'mods/umil_vote_reminder_install';

/*
* The array of versions and actions within each.
* You do not need to order it a specific way (it will be sorted automatically), however, you must enter every version, even if no actions are done for it.
*
* You must use correct version numbering.  Unless you know exactly what you can use, only use X.X.X (replacing X with an integer).
* The version numbering must otherwise be compatible with the version_compare function - http://php.net/manual/en/function.version-compare.php
*/
$versions = array(

	// Version 0.0.1
	'0.0.1'	=> array(
		// Lets add config settings
		'config_add' => array(
			array('vote_reminder_topic_id', '0'),
			array('vote_reminder_optional', '0'),
		),
		// Lets add a new column to the phpbb_users and topics table
		'table_column_add' => array(
			array('phpbb_users', 'user_vote_reminder', array('BOOL', 0)),
			array('phpbb_topics', 'poll_vote_compulsory', array('BOOL', 0)),
		),		
	),
	
	// Version 0.0.2
	'0.0.2' => array(
		// Nothing changed in this version.
	),
	
	// Version 1.0.0-RC1
	'1.0.0-RC1' => array(
		// Nothing changed in this version.
		// Lets add config settings
		'config_add' => array(
			array('vote_reminder_enable', false),
		),
		// Lets remove config settings
		'config_remove' => array(
			array('vote_reminder_optional', '0'),
		),
		
		// Alright, now lets add some modules to the ACP
		'module_add' => array(
			// Now we will add the avatar mode from acp_board to the ACP_CAT_TEST_MOD category using the "manual" method.
            array('acp', 'ACP_MESSAGES', array(
			'module_basename'   => 'vote_reminder',
			'module_langname'   => 'ACP_VOTE_REMINDER',
			'module_mode'       => 'votes',
			'module_auth'       => 'acl_a_forum',
				)
			),
		),		
		
	),
	
	// Version 1.0.0-RC2
	'1.0.0-RC2' => array(
		// Lets add config settings
		'config_add' => array(
			array('vote_reminder_who_voted', false),
		),
		// Now to add some permission settings
		'permission_add' => array(
			array('u_vote_reminder', true),
		),		
	),
	
	// Version 1.0.0-RC3
	'1.0.0-RC3' => array(
		// Lets add config settings
		'config_add' => array(
			array('vote_reminder_interval', '0'),
		),
		// Lets add a new column to the phpbb_users and topics table
		'table_column_add' => array(
			array('phpbb_users', 'user_last_vote_reminder', array('TIMESTAMP', 0)),
		),		
	),
	
	// Version 1.0.0
	'1.0.0' => array(
		// Lets update a column in phpbb_users, thus new registered users won't have to cast votes once logging in to board
		'table_column_update' => array(
			array('phpbb_users', 'user_vote_reminder', array('BOOL', 1)),
		),		
		// Nothing changed in this version.
	),

	
);

// Include the UMIF Auto file and everything else will be handled automatically.
include($phpbb_root_path . 'umil/umil_auto.' . $phpEx);


?>
[URL: http://www.generacionretro.net/
Versión phpBB: phpBB3 (3.0.14)
MODs Instalados:
| Mostrar
Advanced BBCode Box 3 (aka ABBC3)
AOS notificaciones
AOS Quien a Visitado un Tema
Guests Past 24 hours on index
Default Random 'No Avatar'.
Inactive and Banned Users` Custom Titles & Avatars
Prime Trash Bin
Introduciator
Advanced Rules Page
Ultimate Points
Hidden content until reply
phpBB3 Form Maker/Creator Mod
Thanks for posts
Pay For Link MOD v1.0.2
Notify topic starter on moderator action
Special and Normal Rank Images
Welcome on index
Report to topic
Prime Post Revisions
Profile Fields Control MOD
Topic solved
PM Spy
Post Models
Custom Header Logo
Activity Stats MOD
ACP Add User MOD
NV advanced last topic titles
Auto Groups MOD
Topic Evaluation/Rating
Quick Title Edition
MOD Version Check
Prime Warnings
Post Bot
Share On
Categorize Announcements and Stickies
Profile Views List
User Rank Progression Bar
Adaptive Hide BBcodes
Hidden content for groups can view
Menu System
New topics need approval
Moderator Messages
Prime Subject Check
Topic in "Who is Online"
Moderator Needed
Parse BBCode in Custom Profile Fields
Prime Links
cBB Blockgets
Country Flags User Edition
Youtube Videos Gallery
Username Colour Change MOD
Topics Icons in new column
Medal System
Sitemap FX
Official Topic Index
Static Pages
Advertisement Management
Pastebin
User Reminder
Anti Double Post
Welcome PM on first Login (WPM)
Precise Similar Topics II
Profile friends list mod
Prime Notify
View Poster IP in viewtopic
Auto Backup
Limit Post as Count per Forum
Modification of Terms of Use
Multiple Newsletter Add On
Smashable Christmas Lights
Force To Read Topics
Upcoming Birthday list
cBB Blog
First Topic [pic] on Forum Index
JQ Preview
Forum Viewer
SmiX.MODs Feed News Center
FIND
Topics Only Visible to OP
Advanced Smilies Table
cBB Chat
cBB Chat Addon para cBB Blockgets
Classifieds MOD
Referral MOD With Contests
phpBB Gallery
phpBB Topic Tagging
Mini News
Post Count Requirements
Guest Views
Plantilla(s) usada(s): prosilver
Servidor: pagado generacionretro.net
Conversión desde otro sistema de foros: no

Avatar de Usuario
leviatan21
Ex Staff
Mensajes: 8279
Registrado: 26 Mar 2008, 20:06
Género:
Edad: 55

user remeinder  Tema Solucionado

#2

Mensaje por leviatan21 »

Según el instalador en la tabla de usuarios ( phpbb_users ) debe haber una columna llamada user_vote_reminder cuyo tipo de columna debe ser BOOL (boleano) y con valor predeterminado 1
Lo puedes hacer desde phpmyadmin
Normas de phpBB España | Normas de Soporte
No doy soporte por privado : tenga en cuenta que su problema, también puede ser el problema de otro usuario.
Cualquier mensaje privado no solicitado será ignorado :twisted:

"Education is what remains after one has forgotten everything he learned in school" - Albert Einstein

Nacho1191
Miembro
Mensajes: 246
Registrado: 11 Ene 2005, 07:25
Género:
Edad: 41

user remeinder

#3

Mensaje por Nacho1191 »

leviatan21 escribió:Según el instalador en la tabla de usuarios ( phpbb_users ) debe haber una columna llamada user_vote_reminder cuyo tipo de columna debe ser BOOL (boleano) y con valor predeterminado 1
Lo puedes hacer desde phpmyadmin
y como sería esa instruccion???

EDIT: lo hice asi:

Código: Seleccionar todo

ALTER TABLE `phpbb_users` ADD `user_vote_reminder` BOOL NOT NULL DEFAULT 1
y me funcionó perfect.

gracias gabriel
Última edición por Nacho1191 el 11 Nov 2010, 19:27, editado 1 vez en total.
[URL: http://www.generacionretro.net/
Versión phpBB: phpBB3 (3.0.14)
MODs Instalados:
| Mostrar
Advanced BBCode Box 3 (aka ABBC3)
AOS notificaciones
AOS Quien a Visitado un Tema
Guests Past 24 hours on index
Default Random 'No Avatar'.
Inactive and Banned Users` Custom Titles & Avatars
Prime Trash Bin
Introduciator
Advanced Rules Page
Ultimate Points
Hidden content until reply
phpBB3 Form Maker/Creator Mod
Thanks for posts
Pay For Link MOD v1.0.2
Notify topic starter on moderator action
Special and Normal Rank Images
Welcome on index
Report to topic
Prime Post Revisions
Profile Fields Control MOD
Topic solved
PM Spy
Post Models
Custom Header Logo
Activity Stats MOD
ACP Add User MOD
NV advanced last topic titles
Auto Groups MOD
Topic Evaluation/Rating
Quick Title Edition
MOD Version Check
Prime Warnings
Post Bot
Share On
Categorize Announcements and Stickies
Profile Views List
User Rank Progression Bar
Adaptive Hide BBcodes
Hidden content for groups can view
Menu System
New topics need approval
Moderator Messages
Prime Subject Check
Topic in "Who is Online"
Moderator Needed
Parse BBCode in Custom Profile Fields
Prime Links
cBB Blockgets
Country Flags User Edition
Youtube Videos Gallery
Username Colour Change MOD
Topics Icons in new column
Medal System
Sitemap FX
Official Topic Index
Static Pages
Advertisement Management
Pastebin
User Reminder
Anti Double Post
Welcome PM on first Login (WPM)
Precise Similar Topics II
Profile friends list mod
Prime Notify
View Poster IP in viewtopic
Auto Backup
Limit Post as Count per Forum
Modification of Terms of Use
Multiple Newsletter Add On
Smashable Christmas Lights
Force To Read Topics
Upcoming Birthday list
cBB Blog
First Topic [pic] on Forum Index
JQ Preview
Forum Viewer
SmiX.MODs Feed News Center
FIND
Topics Only Visible to OP
Advanced Smilies Table
cBB Chat
cBB Chat Addon para cBB Blockgets
Classifieds MOD
Referral MOD With Contests
phpBB Gallery
phpBB Topic Tagging
Mini News
Post Count Requirements
Guest Views
Plantilla(s) usada(s): prosilver
Servidor: pagado generacionretro.net
Conversión desde otro sistema de foros: no

Avatar de Usuario
leviatan21
Ex Staff
Mensajes: 8279
Registrado: 26 Mar 2008, 20:06
Género:
Edad: 55

Re: user remeinder

#4

Mensaje por leviatan21 »

Excelente, espero que ese sea el único código faltante
Normas de phpBB España | Normas de Soporte
No doy soporte por privado : tenga en cuenta que su problema, también puede ser el problema de otro usuario.
Cualquier mensaje privado no solicitado será ignorado :twisted:

"Education is what remains after one has forgotten everything he learned in school" - Albert Einstein

Cerrado

Volver a “Soporte de MODs”