Skocz do zawartości
"Idzie nowe..." - o zmianach i nie tylko ×
Przeniesienie zakupów z IPS Marketplace / Moving bought items from IPS Marketplace ×

Tricky

Użytkownik
  • Postów

    116
  • Dołączył

  • Ostatnia wizyta

Odpowiedzi opublikowane przez Tricky

  1. ^^,) im sorry, but its still IPS Error.

    error:

    Date: Sat, 19 Dec 2009 19:07:48 +0000
    Error Number: 1054
    Error: Unknown column 'dr.ssupload' in 'on clause'
    IP Address: 95.34.31.102
    Page: /page/2
    Debug: array (
     1 => 
     array (
       'file' => '/home/wallb0/public_html/ips_kernel/classDb.php',
       'line' => 1019,
       'function' => 'query',
       'class' => 'db_driver_mysql',
     ),
     3 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/sources/pages.php',
       'line' => 137,
       'function' => 'eval',
       'class' => NULL,
     ),
     4 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 589,
       'function' => 'recachePage',
       'class' => 'pageBuilder',
     ),
     5 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 413,
       'function' => '_getPageContent',
       'class' => 'public_ccs_pages_pages',
     ),
     6 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 121,
       'function' => '_view',
       'class' => 'public_ccs_pages_pages',
     ),
     7 => 
     array (
       'file' => '/home/wallb0/public_html/admin/sources/base/ipsController.php',
       'line' => 291,
       'function' => 'doExecute',
       'class' => 'public_ccs_pages_pages',
     ),
    )
    mySQL query error: SELECT f.file_id, f.file_name,m.name as uname,dr.record_thumb FROM downloads_files f  LEFT JOIN members m ON ( f.file_submitter=m.member_id ) 
    LEFT JOIN downloads_files_records dr ON ( dr.record_file_id=f.file_id AND dr.ssupload="ssupload" )   ORDER BY f.file_id DESC LIMIT 0,18
    

    /* Init */
           $return  = "";
           $to_show = 18;
           $per_row = 6;
           $count   = 0;
    
           /* Query */
           $this->DB->build( array( 'select'  => 'f.file_id, f.file_name',
                                   'from'     => array( 'downloads_files' => 'f' ),
                                   'add_join' => array( 
                                                                                                           0 => array( 'select' => 'm.name as uname',
                                                                   'from'   => array( 'members' => 'm' ),
                                                                                                                       'where'  => 'f.file_submitter=m.member_id',
                                                                                                                       'type'   => 'left' ),
                                                                                                           1 => array( 'select' => 'dr.record_thumb',
                                                                   'from'   => array( 'downloads_files_records' => 'dr' ),
                                                                                                                       'where'  => 'dr.record_file_id=f.file_id AND dr.ssupload="ssupload"',
                                                                                                                       'type'   => 'left',
                                                                                                                                   'limit'  => array(0, 1),
                                                                                                                                   'order'  => 'dr.' )                                                                                                                                                                             
                                                                                                                                    ),
                                   'order'    => 'f.file_id DESC',
                                   'limit'    => array( 0, $to_show ),
                                           )          );
           $this->DB->execute();
    
           /* Got some rows */
           if ( $this->DB->getTotalRows() )
           {
                   $return .= "<div><table><tr>";
    
                   while ( $row = $this->DB->fetch() )
                   {
                           $count++;
                           $return .= <<<EOF
    <td class='short'>
           <a href="index.php?app=downloads&showfile={$row['file_id']}">
    EOF;
    
                           if ( $row['record_thumb'] )
                           {
                                   $return .= <<<EOF
                   <img src="index.php?app=downloads&module=display&section=screenshot&id={$row['file_id']}" width='128' height='100'  alt="{$row['file_name']}" />
    EOF;
                           }
                           else
                           {
                                   $return .= <<<EOF
                   <em>No Screenshot Available</em>
    EOF;
                           }
    
                           $return .= <<<EOF
           </a><br />
           <i>By:</i> <strong>{$row['uname']}</strong>
    </td>
    EOF;
    
                           /* New row */
                           if ( $count && $count % $per_row == 0 )
                           {
                                   $return .= "</tr><tr>";
                           }
                   }
    
                   $return .= "</tr></table></div>";
           }
    
           /* Return */
           print $return;
    

  2. Date: Sat, 19 Dec 2009 17:08:44 +0000
    Error Number: 1054
    Error: Unknown column 'f.file_ssurl' in 'field list'
    IP Address: 95.34.31.102
    Page: /page/2
    Debug: array (
     1 => 
     array (
       'file' => '/home/wallb0/public_html/ips_kernel/classDb.php',
       'line' => 1019,
       'function' => 'query',
       'class' => 'db_driver_mysql',
     ),
     3 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/sources/pages.php',
       'line' => 137,
       'function' => 'eval',
       'class' => NULL,
     ),
     4 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 589,
       'function' => 'recachePage',
       'class' => 'pageBuilder',
     ),
     5 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 413,
       'function' => '_getPageContent',
       'class' => 'public_ccs_pages_pages',
     ),
     6 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 121,
       'function' => '_view',
       'class' => 'public_ccs_pages_pages',
     ),
     7 => 
     array (
       'file' => '/home/wallb0/public_html/admin/sources/base/ipsController.php',
       'line' => 291,
       'function' => 'doExecute',
       'class' => 'public_ccs_pages_pages',
     ),
    )
    mySQL query error: SELECT f.file_id, f.file_name, f.file_ssurl,m.name as uname,dr.record_thumb FROM downloads_files f  LEFT JOIN members m ON ( f.file_submitter=m.member_id ) 
    LEFT JOIN downloads_files_records dr ON ( dr.record_file_id=f.file_id AND dr.ssupload="ssupload" )   ORDER BY f.file_id DESC LIMIT 0,18
    

  3. thanks, but, still gives me error

    Date: Sat, 19 Dec 2009 15:37:20 +0000
    Error Number: 1054
    Error: Unknown column 'f.file_ssurl' in 'field list'
    IP Address: 95.34.31.102
    Page: /page/2
    Debug: array (
     1 => 
     array (
       'file' => '/home/wallb0/public_html/ips_kernel/classDb.php',
       'line' => 1019,
       'function' => 'query',
       'class' => 'db_driver_mysql',
     ),
     3 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/sources/pages.php',
       'line' => 137,
       'function' => 'eval',
       'class' => NULL,
     ),
     4 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 589,
       'function' => 'recachePage',
       'class' => 'pageBuilder',
     ),
     5 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 413,
       'function' => '_getPageContent',
       'class' => 'public_ccs_pages_pages',
     ),
     6 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 121,
       'function' => '_view',
       'class' => 'public_ccs_pages_pages',
     ),
     7 => 
     array (
       'file' => '/home/wallb0/public_html/admin/sources/base/ipsController.php',
       'line' => 291,
       'function' => 'doExecute',
       'class' => 'public_ccs_pages_pages',
     ),
    )
    mySQL query error: SELECT f.file_id, f.file_name, f.file_ssurl,m.name as uname FROM downloads_files f  LEFT JOIN members m ON ( f.file_submitter=m.member_id )   ORDER BY f.file_id DESC LIMIT 0,18
    

  4. mhm, after i added the "last Downloads code" in unreal portal or ip.content,

    i get Fatal Error, IPS error, and the Fail code are the one below:

    
    ===================================================
    Date: Sat, 19 Dec 2009 11:15:44 +0000
    Error Number: 1054
    Error: Unknown column 'f.file_ssname' in 'field list'
    IP Address: 95.34.31.102
    Page: /page/2
    Debug: array (
     1 => 
     array (
       'file' => '/home/wallb0/public_html/ips_kernel/classDb.php',
       'line' => 1019,
       'function' => 'query',
       'class' => 'db_driver_mysql',
     ),
     3 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/sources/pages.php',
       'line' => 137,
       'function' => 'eval',
       'class' => NULL,
     ),
     4 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 589,
       'function' => 'recachePage',
       'class' => 'pageBuilder',
     ),
     5 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 413,
       'function' => '_getPageContent',
       'class' => 'public_ccs_pages_pages',
     ),
     6 => 
     array (
       'file' => '/home/wallb0/public_html/admin/applications_addon/ips/ccs/modules_public/pages/pages.php',
       'line' => 121,
       'function' => '_view',
       'class' => 'public_ccs_pages_pages',
     ),
     7 => 
     array (
       'file' => '/home/wallb0/public_html/admin/sources/base/ipsController.php',
       'line' => 291,
       'function' => 'doExecute',
       'class' => 'public_ccs_pages_pages',
     ),
    )
    mySQL query error: SELECT f.file_id, f.file_name, f.file_ssname,m.name as uname FROM downloads_files f  LEFT JOIN members m ON ( f.file_submitter=m.member_id )   ORDER BY f.file_id DESC LIMIT 0,5
    

    and i want it to work with 3.0.5, witch it doest!

  5. code works in 3.0.4, but not in 3.0.5

    ===================================================
    Date: Sat, 12 Dec 2009 20:29:03 +0000
    Error Number: 1064
    Error: 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 '' at line 1
    IP Address: **REMOVED**
    Page: /forums/index.php?app=downloads&module=display&section=download&do=confirm_download&id=270
    Debug: array (
     1 => 
     array (
       'file' => '/home/dfbor/public_html/forums/ips_kernel/classDb.php',
       'line' => 1019,
       'function' => 'query',
       'class' => 'db_driver_mysql',
     ),
     4 => 
     array (
       'file' => '/home/dfbor/public_html/forums/admin/applications_addon/ips/downloads/modules_public/display/download.php',
       'line' => 104,
       'function' => '_displayConfirm',
       'class' => 'public_downloads_display_download',
     ),
     5 => 
     array (
       'file' => '/home/dfbor/public_html/forums/admin/sources/base/ipsController.php',
       'line' => 291,
       'function' => 'doExecute',
       'class' => 'public_downloads_display_download',
     ),
    )
    mySQL query error: SELECT file_name, file_id, file_cat, file_open, file_submitter, file_name_furl FROM ibf_downloads_files WHERE file_id=

  6. I get ips error or fatal error when i use this..

    possible to fix it?

    <?php
           /* Init */
           $return  = "";
           $to_show = 18;
           $per_row = 6;
           $count   = 0;
    
           /* Query */
           $this->DB->build( array( 'select'   => 'f.file_id, f.file_name, f.file_ssname',
                                                            'from'     => array( 'downloads_files' => 'f' ),
                                                            'add_join' => array( 0 => array( 'select' => 'm.name as uname',
                                                                                                                             'from'   => array( 'members' => 'm' ),
                                                                                                                             'where'  => 'f.file_submitter=m.member_id',
                                                                                                                             'type'   => 'left' ) ),
                                                            'order'    => 'f.file_id DESC',
                                                            'limit'    => array( 0, $to_show ),
                                           )          );
           $this->DB->execute();
    
           /* Got some rows */
           if ( $this->DB->getTotalRows() )
           {
                   $return .= "<div><table><tr>";
    
                   while ( $row = $this->DB->fetch() )
                   {
                           $count++;
                           $return .= <<<EOF
    <td class='short'>
           <a href="index.php?app=downloads&showfile={$row['file_id']}">
    EOF;
    
                           if ( $row['file_ssname'] )
                           {
                                   $return .= <<<EOF
                   <img src="index.php?app=downloads&module=display&section=screenshot&id={$row['file_id']}" width='128' height='100'  alt="{$row['file_name']}" />
    EOF;
                           }
                           else
                           {
                                   $return .= <<<EOF
                   <em>No Screenshot Available</em>
    EOF;
                           }
    
                           $return .= <<<EOF
           </a><br />
           <i>By:</i> <strong>{$row['uname']}</strong>
    </td>
    EOF;
    
                           /* New row */
                           if ( $count && $count % $per_row == 0 )
                           {
                                   $return .= "</tr><tr>";
                           }
                   }
    
                   $return .= "</tr></table></div>";
           }
    
           /* Return */
           print $return;
    ?>
               </td>
           </tr>
       </tbody>
    </table>
    

  7. for the last image

                    
    <br><shadow><a href="http://digitalbin.org/index.php?app=gallery&module=images&section=viewimage&img={$row['picid']}"> 
                       <img style="-moz-border-radius: 3px; -webkit-border-radius: 3px; border: 1px solid grey; padding: 1px;" src="http://digitalbin.org/uploads/{$row['directory']}/tn_{$row['masked_file_name']}" alt="{$row['caption']}"/>
                   </a><br />
                   <i>By:</i> <a href='http://digitalbin.org/index.php?app=gallery&module=user&user={$row['member_id']}'>{$row['uname']}</a></strong><br />{$row['number']}
                   <br />
    

×
×
  • Dodaj nową pozycję...

Powiadomienie o plikach cookie

Umieściliśmy na Twoim urządzeniu pliki cookie, aby pomóc Ci usprawnić przeglądanie strony. Możesz dostosować ustawienia plików cookie, w przeciwnym wypadku zakładamy, że wyrażasz na to zgodę.