Support Forums

Problem substracting data from database

This is a discussion on Problem substracting data from database within the Technical Support forums, part of the Technical Support Forums category; What version of 68 Classifieds are you running? V4.1.6 Developer What template are you using? Templatecodes's nustyle Please describe in ...


Go Back   68 Classifieds Forums > Technical Support Forums > Technical Support

This topic is resolved.

If you have a similar issue that this thread does not address, open a new related support topic.

 
Thread Tools Display Modes
Old 12-21-2009, 06:50 AM   #1
Customer
 
damiun's Avatar
 
Join Date: Apr 2009
Posts: 412
Rep Power: 20
damiun is on a distinguished road
Default Problem substracting data from database

What version of 68 Classifieds are you running?
V4.1.6 Developer

What template are you using?
Templatecodes's nustyle


Please describe in detail the issue you are having:
When a user edits his or her details the details are saved in the mysql.
But on listing he or she created the old details are still visible (only for the phone).

I tried changing the details in the admin and again its saved in the mysql but not in the listing.
I tired emptying my history and cookies but no luck so far.

Dominick

p.s. i debugged the page and the details in the debug are old also, the phone is not the same as in the mysql database in the users class
damiun is offline  
Old 12-21-2009, 09:33 AM   #2
curmudgeon
 
Join Date: Mar 2006
Posts: 5,416
Rep Power: 139
Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light
Default

68C can only get data from the database, the old phone number cant be stored anywhere else so if its right in the database you have to ask yourself where the "old" number is comming from. For example are you mixing up an extra field called phone and the users registration details?
__________________
Larry

Knowledge learned is more valuable than knowledge given.
Lhotch is offline  
Old 12-21-2009, 10:31 AM   #3
Customer
 
damiun's Avatar
 
Join Date: Apr 2009
Posts: 412
Rep Power: 20
damiun is on a distinguished road
Default

Hi,

I am using {$phone} which I think is an account field.

But if i place a listing and change my number (step 6 - check your details step) it only usses that number for that listing.
So if I have 10 listings and i want to change my phone number i have to change it 10 times?

So phone is a listing field,
But is there a way to change it for every field?
damiun is offline  
Old 12-21-2009, 10:39 AM   #4
Customer
 
damiun's Avatar
 
Join Date: Apr 2009
Posts: 412
Rep Power: 20
damiun is on a distinguished road
Default

Hi,

This is what I checked:

- The phonenumber ($phone) is 06......

I checked in the admin if the alternate adress isnt checked, it isnt
The phone linked to this acocunt (manage users in the administration) is empty.
The phone is the alternate adres is empty,
The phone field in the mysql is empty.

I really really dont understand it............
damiun is offline  
Old 12-21-2009, 10:41 AM   #5
curmudgeon
 
Join Date: Mar 2006
Posts: 5,416
Rep Power: 139
Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light Lhotch is a glorious beacon of light
Default

I beleive phone in step6 is for the "order" and no there is no way to change them all aside from running a manual query against the order table.
__________________
Larry

Knowledge learned is more valuable than knowledge given.
Lhotch is offline  
Old 12-21-2009, 10:53 AM   #6
Customer
 
damiun's Avatar
 
Join Date: Apr 2009
Posts: 412
Rep Power: 20
damiun is on a distinguished road
Default

Hi,

So the input in step 6 is used to display in the listing layout (viewlisting).
But why does the account also has a phone number?

So there are 2 phone fields, one defined during checkout for the listing, and one defined during registration in the account....

Dominick

P.s.

I placed 3 listings

Listing 1: title 1111111111
changed during step 6 phonenumber to : 111111111111

when the listing was created: phone: ..


Listing 2: title 222222
changed during step 6 phonenumber to : 22222

when the listing was created: phone: 111111111111111

Listing 3: title 3333333
changed during step 6 phonenumber to : 333333333333

when the listing was created: phone: 222222222

So its also not taking the recent changes...... i created a ticket because its getting really complicated

Last edited by damiun; 12-21-2009 at 10:59 AM.
damiun is offline  
Old 12-21-2009, 04:01 PM   #7
68 Classifieds Staff
 
Eric Barnes's Avatar
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 5,489
Rep Power: 136
Eric Barnes is just really nice Eric Barnes is just really nice
Default

On a stock install the phone is only stored in the users table. If you created an extra field for phone then that may be causing the confusion.
__________________
Eric Barnes
68 Classifieds Developer
Customer Area | Issue Tracker | Documentation | 68C Mods | 68 @ Twitter | My Modules
Eric Barnes is offline  
Old 12-21-2009, 04:17 PM   #8
Customer
 
damiun's Avatar
 
Join Date: Apr 2009
Posts: 412
Rep Power: 20
damiun is on a distinguished road
Default

I checked it and i am really talking about $phone
damiun is offline  
Old 12-22-2009, 05:01 AM   #9
All Hands On Deck
 
seymourjames's Avatar
 
Join Date: Mar 2008
Posts: 3,529
Rep Power: 89
seymourjames is a jewel in the rough
Default

Are you using the alternative address module by any chance? This module by the way was discontinued quite a while ago.
__________________
"The fool doth think he is wise, but the wise man knows himself to be a fool.".

TemplateCodes.com for 68C
seymourjames is offline  
Old 12-22-2009, 10:15 AM   #10
Customer
 
damiun's Avatar
 
Join Date: Apr 2009
Posts: 412
Rep Power: 20
damiun is on a distinguished road
Default

@seymourjames,

Yes i am using the alternative address module.

Dominick
damiun is offline  
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting data from a database help skekum TemplateCodes 2 08-26-2009 06:30 AM
Duplicated installation and database, but display problem.. sitewonders Technical Support 3 07-15-2009 06:45 AM
installation problem, lots of database errors Chooser Technical Support 5 09-08-2008 10:09 AM
Data Import Problem on a Windows Server sporthorsebreeder Off Topic 4 10-09-2006 09:49 AM


All times are GMT -4. The time now is 06:22 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0