phpBB España Oficial

Publicado: **02 Mar 2007, 20:12**

Bueno instale yellow card mod, con Easy mod, y al terminar de instalar creo que tengo que ejecutar yellow_card_db_update.php, pero no se si tengo que ejecutarlo desde la URL, http://nbaspain.freehostia.com/foro/adm ... update.php o desde phpMyAdmin, he probado las dos cosas pero na, en el sql me dice:

Código: Seleccionar todo


Parece haber un error en su consulta de SQL. La salida generada por el servidor de MySQL, de existir, aparece abajo, en cuyo caso puede ayudar a diagnosticar el problema.

ERROR: Signo de puntuación desconocido @ 160
STR: ://
SQL: <?php
#########################################################
## SQL commands to phpBB2
## Author: Niels Chr. R�d
## Nickname: Niels Chr. Denmark
## Web: http://mods.db9.dk
## Email: ncr@db9.dk
##
## Ver 1.0.9
##
## phpBB2 database update script for mods
## this file is intended to use with phpBB2, when installing mods
## after so you may delete this file, but only admin can use so it really doesen't matter
## The script will look what prefix you are using, and use the existing DB defined by congig.php
## The execution of this script's included SQL is harmless, so you can run it as meny times you like
## note, though that the users last visit, will be set back to his/her last login, 
## but that is a minor cosmetic isue, that will correct it self next time the use  logs in
##
## the following example are from my mods, and you can add some self, for other mods if you like
## you will after execution get a list over those commands that are run with succes and those with warnings !
## delete the sample lines if you are using it only for other mods
##
#########################################################

define('IN_PHPBB', true)

consulta SQL:

<?php ######################################################### ## SQL commands to phpBB2 ## Author: Niels Chr. R�d ## Nickname: Niels Chr. Denmark ## Web: http://mods.db9.dk ## Email: ncr@db9.dk ## ## Ver 1.0.9 ## ## phpBB2 database update script for mods ## this file is intended to use with phpBB2, when installing mods ## after so you may delete this file, but only admin can use so it really doesen't matter ## The script will look what prefix you are using, and use the existing DB defined by congig.php ## The execution of this script's included SQL is harmless, so you can run it as meny times you like ## note, though that the users last visit, will be set back to his/her last login, ## but that is a minor cosmetic isue, that will correct it self next time the use logs in ## ## the following example are from my mods, and you can add some self, for other mods if you like ## you will after execution get a list over those commands that are run with succes and those with warnings ! ## delete the sample lines if you are using it only for other mods ## ######################################################### define('IN_PHPBB', true)

MySQL ha dicho: Documentación
#1064 - 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 '<?php
#########################################################

Y si lo ejecuto desde la URL:

Código: Seleccionar todo

Warning: main(./extension.inc): failed to open stream: No such file or directory in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 27

Warning: main(./extension.inc): failed to open stream: No such file or directory in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 27

Warning: main(./extension.inc): failed to open stream: No such file or directory in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 27

Warning: main(): Failed opening './extension.inc' for inclusion (include_path='.:/usr/local/lib/php') in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 27

Warning: main(./common.): failed to open stream: No such file or directory in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 28

Warning: main(./common.): failed to open stream: No such file or directory in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 28

Warning: main(./common.): failed to open stream: No such file or directory in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 28

Warning: main(): Failed opening './common.' for inclusion (include_path='.:/usr/local/lib/php') in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 28

Warning: main(./includes/functions_selects.): failed to open stream: No such file or directory in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 29

Warning: main(./includes/functions_selects.): failed to open stream: No such file or directory in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 29

Warning: main(./includes/functions_selects.): failed to open stream: No such file or directory in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 29

Warning: main(): Failed opening './includes/functions_selects.' for inclusion (include_path='.:/usr/local/lib/php') in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 29

Fatal error: Call to undefined function: session_pagestart() in /home/www/nbaspain.freehostia.com/foro/admin/mods/easymod/yellow_card_db_update.php on line 62

Alguien me puede ayudar??

Gracias

Pd:
Si od meteis en http://nbaspain.freehostia.com no os sorprendais al ver que directamente no esta el foro esta una entrada, con los links del foro y el portal

Creo que es por ese mod.

PD2:
Y cuando intento entrar en los foros me aparece esto :

Código: Seleccionar todo

Failed obtaining forum access control lists

DEBUG MODE

SQL Error : 1054 Unknown column 'a.auth_ban' in 'field list'

SELECT a.forum_id, a.auth_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete, a.auth_sticky, a.auth_announce, a.auth_vote, a.auth_pollcreate, a.auth_ban, a.auth_greencard, a.auth_bluecard, a.auth_mod FROM phpbb_auth_access a, phpbb_user_group ug WHERE ug.user_id = 2 AND ug.user_pending = 0 AND a.group_id = ug.group_id AND a.forum_id = 1

Line : 173
File : auth.php

Que se me olvidaba

PD3:
A los invitados si que les deja entrar pero a los usuarios no, he probado a registrarme otra vez, por si acaso era mi usuario.

Editado:
Acabo de volver a probar y a los invitados les deja entrar a los foros pero no ver los posts

Publicado: **02 Mar 2007, 23:36**

Desde este foro siempre se ha dicho que no se recomienda instalar los MOD's con EM, ya que da muchos problemas... es mejor que lo instales tú a mano...

Saludos!!

Publicado: **05 May 2007, 00:44**

alguien puede ayudarle por favor? a mi me pasa exactamente el mismo problema.

sustituyo todo bien pero a la hora de ejecutar el db_update y hacer los cambios en la base de datos me da el mismo error que a el.

un saludo.

Publicado: **05 May 2007, 22:36**

Uag.......q' problema........pero vamos por parte.......

1 -NO te recomiendo el EM para instalar MODs, al fin de cuentas trae mas problemas q' practicidad.
2 -La base de datos la tenes q' subir a esta direccion (por medio de FTP):
http://nbaspain.freehostia.com/foro/yel ... update.php (es la misma carpeta q' contiene el index, la carpeta admin, templates, etc.)

despues pones la misma direccion en la barra del explorador y le das "ENTER", te sale una pantalla con unos OKs y listo esa parte, con esto instalas las tablas. Tambien se soluciona tu "PD2"

3 -Subi los archivos "a mano" en su carpeta correspondiente e instalalo "a mano"

phpBB España Oficial

Problema Con Yellow Card Mod

Problema Con Yellow Card Mod

Respuesta: Problema Con Yellow Card Mod

Respuesta: Problema Con Yellow Card Mod

Respuesta: Problema Con Yellow Card Mod