Hola, llevo varios dÃas buscando información que resuelva el problema y no lo he conseguido, he decido pedir ayuda por aquÃ. Disculpen las molestias.
Link to my site: asistenciaexperta.com
SMF version: SMF 2.0
TP version: TP 1.104
Default Forum Language: Español
Theme name and version: Whitebox by, Crip
Browser Name and Version: IE8, Firefox 6.0.1, Chorme, Safari
Related Error messages: 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 ' 42)' at line 3
Mods installed: SA Facebook
Show BBCode to guests
audiblepm 1.5
Simple Audio Video Embedder
The Simpsons Avatars
Street Sign Avatars
Periodic Table Avatars
Blacy E. Avatars
Karma Buttons
Float BBCODE
Google +1
Remove XHTML, RSS & WAP2 Links in Footer
eBay BBCode
Ad Managment
Watermark.light
cbi, 1.0
Justify BBCode
Highslide BBCode and Image Viewer
Highslide 4 SMF
Curve_centered_menu
Disable 'last edit by...' for Administrators
Caps_Lock_Detection_on_Login
TinyPortal
He resuelto el problema de envÃo de artÃculos por los miembros mediante
estas instrucciones, incluso puede que haya cometido un error, ya que se trata de una solución para una versión inferior de TP.
Pero ahora:
Tengo un error cuando intento ver los artÃculos enviados por los miembros:
Error en la Base de Datos
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 ' 42)' at line 3
..../Sources/TPortalAdmin.php
LÃnea: 1525
htt..../index.php?action=tpadmin;sa=submission
Error en la Base de Datos: 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 ' 42)' at line 3
SELECT id, approved
FROM smf_tp_articles
WHERE FIND_IN_SET(id, 41, 42)
1506: // clean up notices
1507: $request2 = $smcFunc['db_query']('', '
1508: SELECT id, value5
1509: FROM {db_prefix}tp_variables
1510: WHERE type = {string:type}',
1511: array('type' => 'art_not_approved')
1512: );
1513: if($smcFunc['db_num_rows']($request2) > 0)
1514: {
1515: $ids = array();
1516: while($row = $smcFunc['db_fetch_assoc']($request2))
1517: $ids[$row['id']] = $row['value5'];
1518: $smcFunc['db_free_result']($request2);
1519: }
1520: $request = $smcFunc['db_query']('', '
1521: SELECT id, approved
1522: FROM {db_prefix}tp_articles
1523: WHERE FIND_IN_SET(id, {array_int:ids})',
1524: array('ids' => $ids)
==>1525: );