SMF Support > Bosanski/Hrvatski/Srpski (Bosnian/Croatian/Serbian)

[Problem] The database value you're trying to insert does not exist

(1/1)

Marko-_-:
ovako nesto sam cacko i procacko sam ga skroz.
Kada hocu da vidim neciji profil ovo mi izbacuje
The database value you're trying to insert does not exist: num_limit

Branko.:
Valjda znaš gdje si mijenjao? U ACP, preko FTP ili u bazi?

Marko-_-:
radi se o ftp, nesto u sorce mi se pojebalo pa sam instalirao novi smf pa uzeo sorce. nasao sam gresku ovde je u pitanju.
profile-view.php

--- Code: ---135: // Prepare the buddy list.
136: if (isset($modSettings['enable_buddylist']) && $modSettings['enable_buddylist'] == '1') {
137: $buddies = array();
138:
139: if (in_array(@$context['member']['options']['num_shown_buddies'], array(3, 6, 9, 12)))
140: $number = $context['member']['options']['num_shown_buddies'];
141: else
142: $number = $modSettings['profile_buddies_shown'];
143:
144: $request = $smcFunc['db_query']('', '
145: SELECT buddy_id
146: FROM {db_prefix}buddies
147: WHERE id_member = {int:id_member}
148: AND approved = 1
149: ORDER BY position ASC, time_updated DESC
150: LIMIT 0, {int:num_limit}',
151: array(
152: 'id_member' => $context['member']['id'],
153: 'num_limit' => $number
154: )
==>155: ); [color=red]OVDE PROBLEM [/color]
156: while ($row = $smcFunc['db_fetch_assoc']($request))
157: $buddies[] = $row['buddy_id'];
158:
159: loadMemberData($buddies);
160: foreach ($buddies as $buddy) {
161: $user_data = $user_profile[$buddy];
162: $user_data['avatar_image'] = $user_data['avatar'] == '' ? ($user_data['id_attach'] > 0 ? '<img src="' . (empty($user_data['attachment_type']) ? $scripturl . '?action=dlattach;attach=' . $user_data['id_attach'] . ';type=avatar' : $modSettings['custom_avatar_url'] . '/' . $user_data['filename']) . '" alt="" class="avatar" border="0" />' : '') : (stristr($user_data['avatar'], 'http://') ? '<img src="' . $user_data['avatar'] . '"' . $avatar_width . $avatar_height . ' alt="" class="avatar" border="0" />' : '<img src="' . $modSettings['avatar_url'] . '/' . htmlspecialchars($user_data['avatar']) . '" alt="" class="avatar" border="0" />');
163: $user_data['is_online'] = (!empty($user_data['show_online']) || allowedTo('moderate_forum')) && $user_data['is_online'] > 0;
164:
165: if ($buddy != $memID)
166: $context['member']['buddies_data'][$buddy] = $user_data;
167: }
168: }
169:
170: // Profile pictures.
171: if ($modSettings['profile_enable_pictures'] == 1) {
172:
173: // Stupid differences... MySQL uses RAND(), SQLite and PostgreSQL RANDOM()
174: global $db_type;
175: if ($db_type == 'mysql')
--- End code ---

Branko.:
Napiši malo smislenije to što si radio.Odakle si uzeo "sorce" i šta ti taj izraz znači?Je li kompletan folder ili samo Profile-View.php ?Ovo što si priložio nema blage veze sa originalnim Sources\Profile-View.php zato zakači ovdje cijeli fajl da se pogleda.

Navigation

[0] Message Index